Still Stuck in a Hole

[shay]

Hi Eric

I have worked out why the .Requery wasn't working.

When you have a form and subform, you need to define the Link Child and Master fields to keep the data in synch - you do not have to keep redefining the recordsource for the suform as you have with qryDynamic_QBF. I got your Search by group example working by changing your cmbSearchGroup so that it displays the Group and stores the GroupValue. For the subform, I then defined the Link Child field as GroupValue and the Link Master field as cmbSearchGroup.

This done, the subform displays the correct data without you having to click the Find button.

I then thought about your other search criteria and realised that your approach is ok because some of the criteria are so complicated. I can't think of a better solution than the one you're already using ie closing and opening the form.

hth

shay

 

[e2cheng]

hi shay,

thank you so much for taking the time to run through that thing. i hope it didn't cause you too much trouble. stinks that there isn't a better soluntion..

i can't remember exactly when i took out the master/child link fields. i had to take them out for some other function to work properly, not really quite sure what that does. at any rate, thank you once again for patiently going through that stuff with me.

truly grateful,
eric