Please help before I go mad

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

Before I explain my problem, let me start by saying that
I am weak on VB, subforms and Macros.

Here is what I want to do.
I have one table with a bunch of fields on it including
Patient Name and Patient Account Number. This table does
not have any information in it right now.

I have a second table with only two fields on it.
Patient Name and Patient Account Number. This is my
master list of patient names and account numbers.

I have created a form so that the receptionist can key
information into table one. I would like for her to be
able to type the account number on the form and have the
patient name fill out after update of the field.

I created a query with the Patient Name and Account
number master list where it prompts you to type in the
account number. When you do, only one or two records
display. I figure I can build some sort of expression
off of the form's account number field that will use this
query. I have spent hours trying to make this work.

Please help. I am desperate. I will name my first born
after you if you can hand me that missing piece.
Please....
 
Here's a suggestion... create a Combo Box with Row Source of account number
and patient name, then access the patient name as the Column(1) property of
that Combo Box. If you use the limit to list and autoexpand features, it
will give your user some "automatic checking" of what they are typing in.

If it is to bring up an existing record, you might be able to use the third
option on the first screen of the Combo Box wizard to populate your form.

Larry Linson
Microsoft Access MVP
 
Back
Top