selection action

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
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?
 
Back
Top