Filter Help??

A

Access Help

Hi all,
I have a main form and a subform. I have the dropdown in the Main form and
want to filter the subform. The subform is viewed in a a datasheet view. I
have tried eveything I could but no luck. The code I have used tries to
filter the subform but it doesn't do it. Can anyone help me?
thanks
 
W

Wayne-I-M

Hi

Open the main form in design view so you can both the main form and the sub
form.
Click the sub form open the properties box
select the data column
You will Link Child and Link Master fields
Ensure that you have used the correct (same) format field control

As an example if you have an autonumber ID on the main form then you could
use this as the link if it is also on the sub form.
The code I have used tries to filter the subform but it doesn't do it.
Click to expand...

If this is not the problem then please post the code you are using the link
the forms and someone will no doubt give you an answer

Hope this helps
 
A

Access Help

Wayne, Thanks for that, it is working now, but how can I call upp the records
untill the drop down box is used to filter the records?
 
Top