Combo populate different table access97

[databasesrus]

I am using access 97. I have a combo box from a classschedule table from which the user can select a certain class/date/time. After the class is selected I would like the info stored in the classregistration table under the studentID.

I am trying to use the following but it isn't quite right for access 97. Can anyone see where I am off?

If Not IsNull(me.Combo1) Then Table![registration]![class}.value = me.Combo1.Columns(2)

etc.

Is this close? Thank you in advance for any help.

 

[Rolliee]

I could have sworn I answered this one earlier.

rollie@bwsys.net

 

[databasesrus]

i dont see your name on my post so i reckon you didnt.

 

[databasesrus]

ok i see your response now but it doesnt need a query and such i just need the correct syntax to call the table and field in access 97

 

[Rolliee]

the data source for the "Table/ Query" is a query.

Rollie E

 

[databasesrus]

i am obviously not describing my question correctly i will repost