Syntax for access97 to call a table and field

[databasesrus]

Hi i am used to 2000 but am using '97. I have a form which uses a combo box from a table that lists all possible classes/days/times for students to enroll.

When the user selects the class, i would like to store the information in a different table for that student id.

I am trying:

If Not IsNull(combo1) Then Table![Registration]![Class].Value = Me.Combo1.Column(1).Value

but this is slightly off

Can anyone tell me what is wrong in this statement?

Thank you.

 

[JeremyNYC]

You can't do this in any version of access. you have to make a recordset and update that or make a sql statement that does the update for you.

But I'm confused...why would you want to set the value in another table? What do your tables look like? What is this combo box that it's not bound to one of the fields in the underlying recordsource?

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Professional Development for Clients Large and Small

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[databasesrus]

???? i guess i am not posing the question corectly. this is a simple thing so i cant be describing it correctly. i will repost

 

[databasesrus]

one table lists all possible options for any class/day/time available. When the user selects it, i want it to store under that student ID so that the student is then registered in this class. I must be making this seem way too hard cuz I know in 2000 this is simple stuff i just cant get the phrasing right in 97.