Autofilled values through combobox are not getting saved..

[testaccessuser]

Hi



I have 2 tables
Staff table = has 3 columns = Staff id, name , department
Nominations = has 4 columns = Staff id, name, department, class name,

I have created a form...when the person goes to the combobox, it is popultated with the staff ids from the staff table..This is correct.
I chose one of those ids.
The Name and department fields are also populated automatically.
I then write the class name

Now, when i click on "add record" button, the record should be updated in the nominations table. There should be 4 new values in the nominations table (Staff id, name, department and the class name)

BUT
For some reason,
Only Staff id and Class name are getting saved.
Name and department are not getting saved.

Why is it so?
Please help me out..

This is my 1st week of using access..so please be kind enough to keep the solutions and the instructions easy to follow.

[pbaldy]

Does this help?

http://www.baldyweb.com/Autofill.htm

[testaccessuser]

Does this help?

http://www.baldyweb.com/Autofill.htm

I did follow this also
"
If your situation is that rare one where saving the related info is necessary, you'd use the same combo. In the textbox, instead of the formula as the control source, you'd list the field in the Orders table where you wanted the phone number saved. In the after update event of the combo, you'd have code like this to copy the value over:

Me.TextboxName = Me.ComboName.Column(2)
"


i listed the field as [nominations].[name]
and i updated the after event of the combo

but it gave an error like "Me is unrecogonized....." something something.
Was i not supposed to write "Me"??
i wrote Me.name = me.combostuffid.column(1)

[pbaldy]

Me is only valid in VBA code. Did you put that code in the VBA editor?

http://www.baldyweb.com/FirstVBA.htm