Link to home
Create AccountLog in
Avatar of lee_jd
lee_jdFlag for Afghanistan

asked on

Refer to master form in sub-form

I have a master form driven by a query and a sub-form drivern my a query.  It works fine.

On the subform I have a field called Customer in a combo-box.   I want to restrict the values returned in this combo-box based on a field called "Region" on the master form.

It it work like this : The user browses to a master record, then sets the Region field with criteria.  They can then add customers via the sub-form but the customer list will be restricted according to the Region selected on the master form.

SOLUTION
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Is region is a text field & not a lookup ?
If so you need to add "'"
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account