Subform - form sycronization

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 22 May 2007 00:01 GMT

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

Reply to this Message

Joan Wild - 22 May 2007 14:16 GMT

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

Signature

Joan Wild
Microsoft Access MVP

>I should know how to do this, but I dont.
>
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message