Problem getting new data to an open form

[UTS]

(Sorry moderators, originally posted this in the wrong forum)



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

[hertfordkc]

<< 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. >>
This suggests that the update is being made but you can't see it because the query isn't refreshed. Without having details, all I can suggest is that you need to issue a requery.