RCheesley
Registered User.
- Local time
- Today, 13:03
- Joined
- Aug 12, 2008
- Messages
- 243
Hi all,
I'm using tabs on a form, with each "page" having a subform - e.g. page 1 is patient details and has subfrm_patientdetails; page 2 is referrer's details and has subfrm_referrersdetails and so forth. These subforms are each based on an individual query (qry_patientdetails, qry_referrersdetails etc).
I am not sure if this is the best way to accomplish my aim and am quite happy to take suggestions!
I would like to link a field (the patient's NHS number) on each of these and have it automatically update across all the tabs (as the NHS number features in each table to allow for relationships) but I am not sure how? Using afterupdate perhaps? Any help much appreciated
Ruth
I'm using tabs on a form, with each "page" having a subform - e.g. page 1 is patient details and has subfrm_patientdetails; page 2 is referrer's details and has subfrm_referrersdetails and so forth. These subforms are each based on an individual query (qry_patientdetails, qry_referrersdetails etc).
I am not sure if this is the best way to accomplish my aim and am quite happy to take suggestions!
I would like to link a field (the patient's NHS number) on each of these and have it automatically update across all the tabs (as the NHS number features in each table to allow for relationships) but I am not sure how? Using afterupdate perhaps? Any help much appreciated
Ruth
