Record selection

[A10 Instructor]

I've created a form by selecting a table and use the insert menu command. I placed all fields from the table onto the form along with a combo box set to find a record based on the value I select in the combo box.

Everything works great. I've noticed that when ever the form opens, the combo box is blank, but the fields from the table that are on the form display the first record of the table. Is there any way to make the table fields blank until I select a record with the combo box?

 

[hog]

I always use unbound text boxes and use code to populate them once the user makes a selection from the combo box.

 

[Pat Hartman]

I don't use unbound forms. They are way too much work. The easiest solution is to manipulate the form's RecordSource. Once the bound form is created and works properly, remove the query from the RecordSource. Make sure the query gets its criteria by referencing the combo. Then in the AfterUpdate event of the combo, simply place the query name in the form's recordSource.