L
Lauren B
I'm having some difficulty using the DLookUp function and am wondering if it
is even feasible for what I'm trying to do.
I have three tables (Users, Preferences, Default--all are related based on
USER_ID)
With corresponding forms (Users, Preferences, Default)
"Users" is the primary form, with "Preferences" being a subform of "Users".
"Default" is a popup that appears after a command button is clicked in
"Users". They do not have a child/master relationship.
I need to write a code for a command button on the "Users" form that will
put the value in the "jurisdiction" field of form "Default" in the "region"
field of form "Preferences" based on the the USER_ID field in the "Default"
table being equal to USER_ID field currently displayed on the "Users" form
Can I use the DLookUp function to accomplish this task, or is there
another/better way to do this?
Thank you very much for any assistance in dealing with this mess.
LB
is even feasible for what I'm trying to do.
I have three tables (Users, Preferences, Default--all are related based on
USER_ID)
With corresponding forms (Users, Preferences, Default)
"Users" is the primary form, with "Preferences" being a subform of "Users".
"Default" is a popup that appears after a command button is clicked in
"Users". They do not have a child/master relationship.
I need to write a code for a command button on the "Users" form that will
put the value in the "jurisdiction" field of form "Default" in the "region"
field of form "Preferences" based on the the USER_ID field in the "Default"
table being equal to USER_ID field currently displayed on the "Users" form
Can I use the DLookUp function to accomplish this task, or is there
another/better way to do this?
Thank you very much for any assistance in dealing with this mess.
LB