"Set field" prob

[cos]

hi guys,

basicly, i got an Add Contact button, which runs the macro attached to this post, what opens a blank form; at which stage i wish for the form to enter a value in one of the fields from another form:

On Load event:

Private Sub Form_Load()
Me.ShopInfoID = [Forms]![zx_Shop]![ShopInfoID_TBL_ShopInfo]

End Sub

when the form is opened in form view, from the click on the Add button on a previous form, the form is opens completely blank with the specifiedID to this form (ContactID) to "New", with the ShopInfoID field blank..

what am i doing wrong? is there some other way of doing this or is access being an idiot yet again?

please see if you can help

 

[stopher]

When a value is entered in ShopInfoID_TBL_ShopInfo, does the user exit from the control? If not, then it's possible that the value has not yet been stored in the control.

Another possibility... is 01_ContactAdd already open? If it is then the OnLoad event won't fire.

hth