Link to home
Start Free TrialLog in
Avatar of J G
J G

asked on

Dlookup issue

I have an unbound form called Advanced_Search.

One field is called Cat/Sub  (referencing a field by same name in the table called  tbl_Cat_Sub)

One field is called Cat/Sub Name (locked/display/read-only)  (referencing a field by same name in the table called  tbl_Cat_Sub)

I want to be able to enter a value in the Cat/Sub field and have the corresponding name lookup and populate in the Cat/Sub name field.


I am using the following formula in the control source, but in design view I am getting a circular reference error, and in Form view I am getting #error

Could you help me adjust the dlookup so it will work?


=DLookUp("[Cat/Sub Name]","[tbl_Cat_Sub]","[Cat/Sub]  = " & [Forms]![Advanced_Search]![Cat/Sub])
SOLUTION
Avatar of bfuchs
bfuchs
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Here's a working example.  It is the fourth item on the menu.
User generated imageFillFormFields130127.zip