microsoft.public.access.gettingstarted

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

"Dennis" wrote:

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