stop subform from populating before combo box on main form is selected

[jaymin]

I have two forms, the first form selects a town, this is used to filter the second form combo box with the names of people from the selected town, the second form has a subform, when the combo box is selected shows what cloths these people have.
what is happening is that before a name is selected in the second form combo box the subform is being populated with data.


what I want to happen is for the subform not to be populated until a name is selected from the second form combo box
Peter

[RuralGuy]

Have you tried not setting the RecordSource of the SubForm until the AfterUpdate event of the second form ComboBox?

[jaymin]

RuralGuy,
Thank you for your reply, being new at this is it possible to explain how i do that.
Peter

[RuralGuy]

Here's a good syntax link: http://access.mvps.org/access/forms/frm0031.htm

[jaymin]

thank for that
Peter

[RuralGuy]

Let us know if you are successful.

[jaymin]

it will be a week before i can get the time, and i will let you know, thanks for the help
Peter

[jaymin]

RuralGuy,
I have played around with the information that you gave me and yes I can now say that it works. Many thanks with your help.
Peter

[RuralGuy]

Excellent! Thanks for posting back with your success.

[jaymin]

the only problem in the end that i had was that it left the fields with an error in the fields of the subform #name? so i created a query with the same field names and put a nul value " " in the criteria of the fields then when I opened the form these field were clear, just how i wanted it, once again many many thanks I have been trying to find a solution for some time.
Peter

[RuralGuy]

If you set the DataEntry property True then the form will *only* display New records (which are initially blank). That might work better for you. Set the SubForm to locked and disabled until you are ready for the user to use it so it looks normal.

[jaymin]

great i will try that thanks, that is for tommorrow

[RuralGuy]

You would not have to leave the RecordSource blank with that method.