link to case file

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

Guest

I have a union query that list our clients in alphabetaical order along with
their case number. How can I link it so that once I find the client I'm
looking for in the query all I have to do is click on the case number to open
the case file that contains that person's info. Now I have to write down the
case number then open another form to get all the information in the case
file.
 
are all the case file records in a single table in the database? if so, then
you can use a listbox or combobox control on a form, using the Union query
as the RowSource, to select the case file. add a command button to the form,
with a macro or VBA code to open the form. include a WHERE clause in the
OpenForm action's arguments, to restrict the form's records to the specific
case file record you selected in the list/combo box control. read up on the
OpenForm topic in Access Help, so you'll understand how the arguments work.
post back with specifics if you have a problem getting it to work.

hth
 
Back
Top