launch form from list box criteria

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

Guest

I have a list box with a name and social security number in it. the social
security number is the bound column. i need a code to launch a form entitled
"New_Visit_Patient_Entry" that opens for the patient highlighted in teh list
box. the patient is already entered into the form, i just need to open it to
review or edit the form.

thank you,
russ
 
Russ,

Like this...
DoCmd.OpenForm "New_Visit_Patient_Entry", , , "[social security
number]='" & Me![social security number] & "'"

Assuming you don't have more than one patient using the same social
security number, this should work ok.
 
Back
Top