Problem getting new data to an open form

[UTS]

I have two tables "Patients" and "Doctors". A main form is used to update the patients records, and there is a section to show the associated doctor details (name, address etc). The patient table records only the Doc_ID, and there is a one to many relationship between the two tables.



To choose a doctor, it is just a matter of selecting him/her from a drop-down list and move on. However, if the doctor is not listed, I have a button that calls a form to add the new doctor to the Doctor table. So far so good.

Unfortunately, the new doctor is not available in the main form until I close and restart the main form. When entering hundreds of records per day, this causes some turbulence to the normally smooth flow.

I would like to be able to add a new doctor and add him/her to the current patient record without having to close/restart the main form.

I have been fiddling around with sub-forms but don't seem to be getting anywhere.

Cheers,
UTS

[Robeen]

You might consider using the Requery method.
It ensures that the Form [or other control] has access to the most recent data.

Here's a link to some documentation:
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

Hope this helps!!

[UTS]

That sounds like the right path.

The Doctor form updates the Doctor table directly, and the doctor details in the main form are from a query [Doctors List]. So, do I put [Doctors List].Requery into the "AfterUpdate" property of the Doctor form?

[Robeen]

I'm not sure whether you would requery the Doctor List 'control' [where your Doctor List is actually displayed] or the Main Form.

Try issuing a Requery on the [drop-down combo box?] control of your Main Form - or the Main Form itself . . .
in the After Update event or the On Close event of the Doctor Form.
I'm not sure which one is better but I would choose the On Close just because it is the last thing [I think] before the Main Form is active again.

All the best!!