Therapist Form

[falcondeer]

Hi,

I have a clinic db where I have a main form with 2 subforms work perfectly. The main form got info about the patient (Name, age...etc), subform 1 got info about the Referral (Referral date, referring clinic...etc) and subform 2 got info about Therapy we provide as physiotherapists (Therapy date, therapist name, type of therapy...etc).

Now I want to create another form where the therapist can choose from a dropdown list (combo) his/her name then all his/her patients appeares along with all related referrals and therapy details, so he/she can add new referral with new therapy details without using the main (patient) form.

I tried but no luck.

Thanks.

 

[gerry@docshop.ie]

I would use the combo box to populate a list box ) with their patient list(Set the Multi Select Property in Other to 'Simple' - i.e. only one record can be selected in the listbox. On the [After Update] event property on the combobox, requery the listbox, I would then use a subform to display the referrals of the selected patient. Set the 'Link Master Field' property of the subform to the listbox and the patient ID in the subform, you could probably reuse the existing referral subform in your new form.

Hope this helps!