Populate textbox form selection on combo box

G

Guest

Hi

I am new to code

I have a query that a unbound combo box is bassed on. The 4th colunm is the
Ingredient ID that I would like to write to textbox Ingredient_Id

I have tried Tom Lake's sugestion

Private Sub Combo12_AfterUpdate()
Me![Ingredient_Id] = Me![Combo12].Column3
End Sub

But I get Object doesn't support this porperty or method, and I do not
understand what it means.

What does the "me" mean?

Thank you

Esrei
 
G

Guest

"Me!" refers to the form in which the code is being written and I don't
think it is really necessary.

I think it should be:

[Ingredient_Id] = [Combo12].Column(3)
 
S

Steve

You need parantheses around the 3 in your code:
Me![Ingredient_Id] = Me![Combo12].Column(3 )

"Me" is a shortcut reference to the form that contains the code.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 

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

Combo box update to field 1
Dependent Combo Boxes 3
Form selection criteria acting independently 1
combo box selection will not populate query correctly 1
auto populate text box based on combo box value 1
filter on combo box possible? 1
How to populate selection from combo box in a table 2
Find using Combo - how to display my own msg if not found 2

Top