on entery of study number find patients last date of followup

[charlotteweasel]

Hi,
I am new to Access and I am building a rather complex database! I am not finding it easy. I work for a hospital and this study follows patients with a particular condition at several different time points. I have designed most of the database but I am having a problem with the outcome form. The client wants the database to look up several things and put them into the outcome form automaticaly on entery of the patients study number.

items include:

last date that the patient was seen
whether the patient has ever had a recorded
" " b recorded
" " c recorded
" " d recorded
" " e recorded
" " f recorded
" " r recorded

The data is stored in the following tables:
demography - one record per person
initial - one record per person
baseline - one record per person
followup - can have many records per person
outcome form - one record per person

I am so stuck and I have tryed to use code but I just can't get the code to work, please help!

thanks!

 

[mvrijnsoever]

Hi Charlotte

If you want to look up that last date a patient was seen use:

DMax("[followup_date]", "TableOutcome", "TableOutcome.PatientID = '" & Me.PatientID & "'&quot

You can use the function DCount to find out how often something was registered for a patient.

You need to put these codes in a specific event. For instance if you want it to be calculated for every record each time then use the "OnCurrent event". There are many other events which you can use too.

Does this answer you question?

Cheers,

marius