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]","[C at/Sub] = " & [Forms]![Advanced_Search]! [Cat/Sub])
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)
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]","[C
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FillFormFields130127.zip