trying to grab value from combo box main to enter into new record

B

babs

Trying to grab for NEW record when man name selected from combo box cboman
want it to input from 1st column-meaning column 0 and put it in text box
named txtName on the subform called datbarbTimeCardMDJEFFSubform2
- getting an error not sure why???


Private Sub cboman_AfterUpdate()
Me.datbarbTimeCardMDJEFFSubform2.txtName = Me.cboman.Column(0)
End Sub

error - method or Data not found

thanks
barb
 
M

Mark A. Sam

Barb,

Try this:

datbarbTimeCardMDJEFFSubform2.Form!txtName = Me.cboman

God Bless,

Mark A. Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Correct syntax for grabbing combobx value from mainfrm to subfrm 5
creating IIF based on check box in sbform,grabbing rate frm Main c 0
syntax parent frm hs combobox want to grabvalue frm combo based on 1
when add new records grabs persons name from Previous record 1
need to check records in subform and delete man name from combo bo 0
filter on combo box possible? 1
Trouble Filtering a Sub Form With Combo Box Options 2
Subform fields auto-filled based on Main form combo box value 8

Top