Automatically update fields based on data entered in primary key f

G

Guest

I hope someone can help me with this; I'm trying to put together a database
for a healthworkers Cardiac Rehabilitation Program, using Access 2003 (in
access 2000 format). I have several tables/forms, one of these holds patient
demographic information, the others hold program attendance information.
What do I need to do so that when the database user selects a patient in one
of the program attendance forms, their demographic data is automatically
updated? So if say, I were recording gym program attendance for example, and
I select a patient from the combo box, can I have the gender, d.o.b and other
fields update with info from that patient? I'm new to Access, and VBA looks
like greek to me but if anyone can help this helpless access user I'd owe
them a beer (or twelve) Thank-you!
 
G

Guest

When you say update, do you actually mean display on the form ?
If this is the case, you could make the DOB, gender etc. fields non-editable
on the form and set the control source to a DLookUp.
E.G.
=DLookUp("[DOB]","[Patient Table]","[Patient ID] = " & [ComboBox].[Patient
ID])
 
G

Guest

Aaaah, yes that did it. Thanks for your help Dennis.

Dennis said:
When you say update, do you actually mean display on the form ?
If this is the case, you could make the DOB, gender etc. fields non-editable
on the form and set the control source to a DLookUp.
E.G.
=DLookUp("[DOB]","[Patient Table]","[Patient ID] = " & [ComboBox].[Patient
ID])


JL said:
I hope someone can help me with this; I'm trying to put together a database
for a healthworkers Cardiac Rehabilitation Program, using Access 2003 (in
access 2000 format). I have several tables/forms, one of these holds patient
demographic information, the others hold program attendance information.
What do I need to do so that when the database user selects a patient in one
of the program attendance forms, their demographic data is automatically
updated? So if say, I were recording gym program attendance for example, and
I select a patient from the combo box, can I have the gender, d.o.b and other
fields update with info from that patient? I'm new to Access, and VBA looks
like greek to me but if anyone can help this helpless access user I'd owe
them a beer (or twelve) Thank-you!
 
S

ShineonSuzie Rhea

Just entered Vista through a new laptop...need lots of areas to call on for
information/and advice.
JL said:
Aaaah, yes that did it. Thanks for your help Dennis.

Dennis said:
When you say update, do you actually mean display on the form ?
If this is the case, you could make the DOB, gender etc. fields
non-editable
on the form and set the control source to a DLookUp.
E.G.
=DLookUp("[DOB]","[Patient Table]","[Patient ID] = " &
[ComboBox].[Patient
ID])


JL said:
I hope someone can help me with this; I'm trying to put together a
database
for a healthworkers Cardiac Rehabilitation Program, using Access 2003
(in
access 2000 format). I have several tables/forms, one of these holds
patient
demographic information, the others hold program attendance
information.
What do I need to do so that when the database user selects a patient
in one
of the program attendance forms, their demographic data is
automatically
updated? So if say, I were recording gym program attendance for
example, and
I select a patient from the combo box, can I have the gender, d.o.b and
other
fields update with info from that patient? I'm new to Access, and VBA
looks
like greek to me but if anyone can help this helpless access user I'd
owe
them a beer (or twelve) Thank-you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top