referencing a subform from main form

[slimjen]

All; I have a form and subform with the following names:

frmBasic
sfrmCustomers

I have a unbound txt field called txtCustID on the mainform
I want to populate this field from a field on the subform called Cust_ID when the record is selected.

I following in the vba event for afterupdate:

Private Sub cboCustNum_AfterUpdate()
   Me.Filter = "[Cust_ID]=" & cboCustNum
   Me.FilterOn = True
   
Me.txtCustID = Forms.frmBasic.sfrmCustomers.Form.Cust_ID
End Sub

The name doesn't appear in the field. What am I doing wrong please?

[June7]

Do you mean an unbound text box?

Why do you need to reference the subform? Isn't the Cust_ID in the combobox?

Me.txtCustID = Me.cboCustNum

What if user navigates to different record in subform by clicking in subform? The textbox is no longer correct.

What tables are these forms bound to?

[slimjen]

I apologize. The unbound text box is for the customer name not ID. I type the wrong field.
txtCustName

the main forms recordsource only contains Customer IDs and the subforms recordsource contains other customer data including the name of the customer. I wanted to put the name of the customer on the main form when the record is selected. I have an unbound combo box on the main form that selects the cooresponding cust id in the subform so that record becomes visible. Hope this helps. thanks

[DubCap01]

I'd put a little cmdbutton on the subform, which when clicked pushes the information the other way. It the subform default view is continuous forms, then the cmdbutton would appear on each record:

Private Sub CmdButton_Click()
Forms!FrmBasic!Cust_ID = me.txtCustID
End Sub

Just give the Command button a useful name for future reference...

cheers
Pete

[slimjen]

i don't understand; cmd button on the subform?

[June7]

Include the customer name as a column in the combobox RowSource then reference that column by its index. Index begins with zero.

Me.txtCust = Me.cboCustNum.Column(1)

Is the subform in datasheet view?

Binding main and subform to same data source seldom works well.

Suggest a standalone form and the search combobox in form header. Or consider split form.

[DubCap01]

Somewhere, on your subform, add a new Command Button. Then, in the On Click event, add the code I wrote above...