Automatically update fields based on data entered in primary key f

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JL - 22 Oct 2007 08:08 GMT

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!

Reply to this Message

Dennis - 23 Oct 2007 07:46 GMT

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])

> 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
[quoted text clipped - 7 lines]
> like greek to me but if anyone can help this helpless access user I'd owe
> them a beer (or twelve) Thank-you!

Reply to this Message

JL - 23 Oct 2007 07:52 GMT

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

> 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
[quoted text clipped - 14 lines]
> > like greek to me but if anyone can help this helpless access user I'd owe
> > them a beer (or twelve) Thank-you!

Reply to this Message

ShineonSuzie Rhea - 31 Oct 2007 21:21 GMT

Just entered Vista through a new laptop...need lots of areas to call on for
information/and advice.

> Aaaah, yes that did it. Thanks for your help Dennis.
>
[quoted text clipped - 28 lines]
>> > owe
>> > them a beer (or twelve) Thank-you!

Reply to this Message