Field should populate other table access 97

[databasesrus]

Please tell me what is the correct syntax for acess 97 to:

The user selects from a combo box to fill a text box.

I want the field of the non-data source table to say exactly what is populated from the combo box.

It should be something like this:

If Not IsNull(Text1) Then Me.Table![ClassRegistration]![Class].Value = Text1

If it can't go directly to the table, I will have it populate another form which has the correct table as its datasource. I just need to know the correct way to format the command because it is telling me that table is not defined.

 

[Rolliee]

to set a value in a table, you either set the value as a bound field on the form or open the table and change or add the value.

'me.' is the alias of a form. I form handles a recordset which is the data in the table(s).


Rollie E