If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide #Name? until find record
I have a SearchForm with subform. I don't want to display any record until
user find the record through cbobox and I will provide RecordSource with where condition in my code just display that one record. So in the design view, I deleted SecordSource in data tab. When I open the form, there is no record, that's good. However, all the fields in my SearchForm display '#Name?' which does not look good. How to hide these #Name? |
#2
|
|||
|
|||
Hide #Name? until find record
I assume you're saying that the "#Name?" is showing in the subform's record?
That suggests that you have no RecordSource for the subform when you first open the form and that the bound controls can't associate to the right fields? If yes, use a RecordSource that includes the correct fields, but also use a WHERE clause that won't return any reords, for the initial RecordSource that your search code can replace, such as: SELECT * FROM Tablename WHERE 1=0; Or, alternatively, make the subform invisible until you've set its RecordSouece, then make it visible. -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "Song Su" wrote in message ... I have a SearchForm with subform. I don't want to display any record until user find the record through cbobox and I will provide RecordSource with where condition in my code just display that one record. So in the design view, I deleted SecordSource in data tab. When I open the form, there is no record, that's good. However, all the fields in my SearchForm display '#Name?' which does not look good. How to hide these #Name? |
Thread Tools | |
Display Modes | |
|
|