launch form from list box criteria

From: Russ (Russ_at_discussions.microsoft.com)
Date: 03/06/05 

Date: Sat, 5 Mar 2005 18:13:03 -0800

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

Relevant Pages

  • Re: Table is too large
    ... This just part of the entire database but what is happening is my users open ... a list of names with social security numbers attached. ... one of the names and it opens a form that shows all of the daily narratives ... table so that when the form opens it pulls all of the records from the linked ...
    (microsoft.public.access.tablesdbdesign)
  • Table relationship problem
    ... Since I will have many duplicate Social Security Numbers, ... The query works just as I need it, but whenever I build a form based on ... It opens with the error the the ... Recordset is not undateable. ...
    (comp.databases.ms-access)
  • Re: To Fell Knight----Russ G
    ... SOCIAL SECURITY CHECK RUSS ... reminds me of "Queen for a day George" at the Golden Nugget ...
    (rec.gambling.poker)