G
Guest
Hello,
I have a main form with a combo that drops down names, eg name of doctor. I
also have an add doctor command button on the main form that opens a form (in
add mode) and adds doctors to the doctors table.
Currently, what I have now is a macro that closes the main form, opens the
add doctor form, and then when the user clicks the close button, it re-opens
the main form. The addition is successful (the new doctor now shows in the
combo drop-down) BUT when the main form re-opens, it does not return to the
current record I was working on. Is there a way to do this? Is there a way to
add the Dr. without closing the main form? I may have multiple times where
this may happen, eg. when a pharmacy name is not there, when a drug name is
not there, etc.
Hopeful,
Rookie.
I have a main form with a combo that drops down names, eg name of doctor. I
also have an add doctor command button on the main form that opens a form (in
add mode) and adds doctors to the doctors table.
Currently, what I have now is a macro that closes the main form, opens the
add doctor form, and then when the user clicks the close button, it re-opens
the main form. The addition is successful (the new doctor now shows in the
combo drop-down) BUT when the main form re-opens, it does not return to the
current record I was working on. Is there a way to do this? Is there a way to
add the Dr. without closing the main form? I may have multiple times where
this may happen, eg. when a pharmacy name is not there, when a drug name is
not there, etc.
Hopeful,
Rookie.