Pulled Data Not Saving

[Rookie]

I use [Form A].[Field Name] to populate [Form B].[Field Name]...but cannot get [Form B].[Field Name] to update in the table. All data entered gets saved to the table associated with [Form B] except this one piece of data. I used this in the Control Source of [Form B] to pull from [Form A]:


=[Forms]![Main Form]![Event ID Number]
The Record Source for Form A is Main Table
The Record Source for Form B is CA Table
Why will this one piece of data not save to the CA Table?

[pkstormy]

Try doing a msgbox after your code to see what value it's grabbing.

Example:
me.SomeFieldName.value = [Forms]![Main Form]![Event ID Number]
msgbox "Value from Main Form Event ID Number = " & me.SomeFieldName.value

You'll either get an error that it cannot find [Event ID Number] on [Main Form] or you'll get a blank value (depending on how the form is designed, you may also need a refresh command.)

me.SomeFieldName.value = [Forms]![Main Form]![Event ID Number]
refresh
msgbox "Value from Main Form Event ID Number = " & me.SomeFieldName.value

or
msgbox "Value from Main Form Event ID Number = " & [Forms]![Main Form]![Event ID Number]

[Rookie]

Wow, thanks for the quick reply! Using your suggestion, it returns the proper value from [Forms]![Main Form]![Event ID Number]. So it is seeing the correct number from [Main Form], but just not saving this number into the "CA Table" when I exit the form.

[pkstormy]

Try adding a refresh command before the form is closed. Do you have an autonumber in the recordsource table? If so, the refresh should work. If not, I'd add one or you may have to do a docmd.saverecord somewhere.

[Rookie]

I was able to solve this by setting the Control Source for Form B to the name of the field in the Table ("CA Table") I wanted to save to, and then adding to the "Default Value" in Properties for the Control in Form B:
=[Forms]![Main Form]![Event ID Number]. I want to make sure you guys all know that I appreciate your help and your quick responses, Thank you!