microsoft.public.access.gettingstarted

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" wrote:

> 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!