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!
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!