Open to Null

[alex]

I have a searchable Form by means of a combo box...

When the Form opens, the same record always appears on the Form, no
matter how I sort the table.

Any advice/hints on how to format/code the Form so that no record
appears on the Form until the users selects a record in the combo box?

alex

 

[Arvin Meyer [MVP]]

Clear out the table sorting, it doesn't do anything except affect the table
view, and data needs to be view in forms or reports anyway. Reports have
their own filtering and sorting. Forms need a query to sort properly, i.e.
base your form on a query rather than on a table. The query can be a saved
query, or a select startement in the form's recordsource property:

Select * From MyTable Order By MyField;

 

[alex]

Clear out the table sorting, it doesn't do anything except affect the table
view, and data needs to be view in forms or reports anyway. Reports have
their own filtering and sorting. Forms need a query to sort properly, i.e.
base your form on a query rather than on a table. The query can be a saved
query, or a select startement in the form's recordsource property:

Select * From MyTable Order By MyField;
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com











- Show quoted text -

Thanks Arvin; I'll give it a try.

alex