Re: launch form from list box criteria

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 03/06/05 

Date: Sun, 06 Mar 2005 15:44:08 +1300

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. 

-- 
Steve Schapel, Microsoft Access MVP
Russ wrote:
> 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

Relevant Pages

  • Re: Security concerns...
    ... PHP and web development for a while now but have never taken on a paid ... to redesign their website with a portion that allows the patient to ... solution or is there a security concern with a shared certificate? ... And BTW - I would never collect any of this information on anything but an in-house host. ...
    (comp.lang.php)
  • Re: Would patients like to be able to email their doctors?
    ... confidentiality than dealing with issues of security. ... least as secure as a paper system (and people already find it easier to ... If, for instance, you allow the patient to decide ... there are lots of published articles about this. ...
    (sci.med)
  • LaBrea still useful?
    ... I'm new to this security stuff, so please be patient and use small words. ... I've just read about LaBrea, a tarpit ...
    (comp.security.misc)
  • Common Law
    ... I work in a hospital and have a question about common law. ... today in the A&E department there was a patient in who was ... towards staff and security were called. ... I'm just asking what common law the sister of the department was ...
    (uk.legal)
  • Re: Access 2003 security warnings
    ... Security in Access is a misnomer. ... You can lock down the mdb files so that people can't get to the database ... Microsoft Access MVP ... Since I do not run 2003, perhaps you could tell me where the macro ...
    (microsoft.public.access.security)