AutoSave Default Field Value (1 Viewer)

[crhodus]

I have 2 field on my "Call-Contact" form, COMPANY_NAME & CONTACT_ID.

The COMPANY_NAME field has its default value set to
=[Forms]![1_Company_Form]![COMPANY_NAME].

The CONTACT_ID field has its default value set to
=[Forms]![1_Company_Form]![COMPANY_NAME] & "-" & [Forms]![1_Company_Form]![COMPANY_NUMBER]

There is also a button on the form that will open another form named "Calls". When the button is pressed, the default values in COMPANY_NAME and CONTACT_ID are not save to my table.

I tried adding Me.Refresh into the VBA text for the button, but this did not solve the problem. Does anyone have any suggestions on how I can get both values in each field saved when the button is pressed?

Thanks in advance!

 

[ElsVanMiert]

Did you try "ME.REQUERY"?

 

[Rich]

You have to find a way to actually activate the form default values are not entered automatically or by "Refresh". You could use an update / insert into sql on another button or a validation procedure to ask if the user wants the default values entered.
HTH