search form help please

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have created a search form that uses a query for the datasource. In the
form header I have an unbound text box with the name of entercode and a
button that has code behind it that does a requery. In the query I have the
criteria for the code field as [forms]![frmsrchbycode]![entercode]. In the
details of the form I have the description fields and a upc number field
(all are flds in the query). When I view the form in formview I only see
the form header until I enter something in the entercode textbox and click
on search.
Is there a way to see the details section of the form when it first opens
without having to enter something?

Thanks in advance...

Karen
 
No. There are no data to be displayed until you select a value in the
unbound text box, as the query needs a value there in order to return any
records. And if there are no records to display, the form will not display
the controls that are bound to those fields * unless * the form is allowing
data entry to occur (AllowAdditions is set to Yes).
 
Back
Top