selection action

G

Gary

Trying to create a database that includes a lookup table with three
selections available.
Depending on the 'location' selected, I want the action to trigger the
opening of another form for further data input relating to that location. I
probably need an 'expression' event built that will process the step? A
Macro? Is there somewhere that I can get information on the 'terminology' and
'language' for creating expressions?

Thanks
 
D

Duane Hookom

You are posting in the modulesdaovba/programming group so this suggests you
might have an idea that this requires code. You can add code to the After
Update event of cboLocation (in your form) that would open another form if
the value of cboLocation is a specific value.
 
G

Gary

Thanks for the reply confirming that it is possible. My question included
asking for some direction for a 'primer' on writing such code. Would
appreciate any direction. Relatively new to Access.
 
D

Duane Hookom

Do you have some form and control names? I expect you want to filter the
opened form to a particular record. Can you describe the relationship between
data on your existing form and the data/records on your new form?
 
Top