Autofill combo value

[survivo01]

I guess I am really missing the boat.
I have a table called classes. This table has classname and classtype.
I am trying to insert date in another table called enrolled based on information from the table classes.


I have made a combo box that inserts the classname and then I have a field next to it that needs the class type. I want the field class type to insert based on what is in classname automatically. I looked on the forum and thought this was the answer.
Private Sub Combo251_AfterUpdate()
Me.Combo232 = Me.Combo251.column2
End Sub
I used the above in my combo box classname using after update

[pbaldy]

You're close, but missed the syntax a bit:

BaldyWeb - Autofill

By the way, I changed your thread title to have more meaning to future users.

[survivo01]

I must be doing something wrong I get error message stating "The object doesn't contain the Automation object 'me.'"

[pbaldy]

Where do you have it? It should be in the VBA editor, not directly in the properties window.

[survivo01]

Not sure I know what you mean. When I go to the property sheet for my combo field ClassName I am clcking on after update and then selecting event procedure it gives me three options I have been picking code and placing the Me.classtype=Me.Classname.column.(1) I then close the code page.

[pbaldy]

That sounds right. There's no period before the column number, so try

Me.classtype=Me.Classname.column(1)

If that doesn't work, can you post the db here?

[survivo01]

Thank you. how do I mark this solved.

[pbaldy]

Happy to help. You can mark it solved in Thread Tools in the green bar just above your first post.