Access: Autopopulate a field on one from using another Form.

[gheyman]

Default Access:

This is Repost with different title - since my original did not meet posting requirements (in error). Sorry started writing the issue and forgot to get back to the title to complete it.
Forum Use Guidelines, especially Item 4: https://www.mrexcel.com/forum/board-...forum-use.html. Titles such as 'Access:' don't qualify.

****************************************************************************************************************************************

I have a button that I want to use as my Event

When I click it, I want the value in a field on separate form to equal the value on the form that has my button

The form that has the button is "frm_ModelGeneral_vluItem1" and the Field name is "ItemID"

I want the value that is in ItemID

to populate

Form: "frm_VendorQuoteData" Field "ITEM_ID"

How do I do this in VBA?

 

[xenou]

Something like (in the first control's after update event or possibly change event):

[Forms]![MyOtherForm].[MyOtherControl].Value = Me.MyControl.Value