Subform - form sycronization

[Guest]

I should know how to do this, but I dont.

When I open my form the main field that everything links to is empy, but the
other field have data from the first record. How do I get it to open so that
all of the fields are blank and will update once the drop down box has a
record chosen? there is a subform and one record in the main form that need
to kept in sync with the drop down box.

Thanks

 

[Joan Wild]

You can set the recordsource of the form to
"SELECT * FROM SomeTable WHERE False"
Then in the afterupdate of the combo set the recordsource to
"SELECT * FROM SomeTable WHERE Whatever = " & Me.NameOfCombo