Open frm in Add mode

[Nour469]

Hello,
I need simple help!
I have a form with a field (DrsName) which is a combo box that looks up values in another table (Drs List). When I come across a name that is not in the list, I need to open the form (Drs List) and add the name. for which I added a cute button. I am having 2 problems:
1) I cannot get the button to open the form in add mode, as I don't want the users to accidently type over the data, I just want to be able to ADD a new name. or at least open the form in data sheet view! I am able to do it in the switchboard but not within my form!
2) when I add the name and come back to my form, the list is not updated until I close the form and re-open it again. which is a problem as I need to find the patient I was working on and choose the name from the list and continue entering the data.

I am sure there is a simple way to do this... I just can't figure it out!

Thanks for the help.
Nour

[DonRayner]

To open your form in add mode you need to use the following code, replace FormName with the name of your form.

DoCmd.OpenForm "FormName", , , , acFormAdd
 

To have the combobox updated after you add a new item add the following to the close event of your new form. Replace MyForm with the name of your form and MyCombobox with the name of your combobox

Forms!MyForm!MyCombobox.requery
 

[Nour469]

Hi,
Thanks for your reply, The first one worked like magic and my form opens in Add mode, But the second one did not work, it keeps giving my errors, not accepting form name...

[DonRayner]

@Nour469
It should work. Please post back the exact text from the error that you are getting.

[Nour469]

Hi Donrayner,

The name of my form was Referring Drs list and it was highlighting the "Drs: in yello but I changed it to: ReferringDrsList which is now fine. the name of my combo box is: referringDr. Now the combo box is is the "Main Form"

I am opening the form: ReferringDrsList and on close I am typing in the code builder:

Forms!ReferringDrsList!ReferringDr.requery

and now I am getting the Run-Time error '2465' can't find the field "ReferringDr"
(The combo box is in the main form, and I have a button whithin the main form to open the form "ReferringDrsList" .....

What am I doing wrong!?
Nour