Populate a table from a form Access 97

[databasesrus]

I'm using '97 and havent' for a while. Could someone please give me a hint on syntax to fill a table field from a form. I have tried

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

I know this is close but i have something wrong with how I have defined the table.

I sure do like the way 2000 works better

Thank to anyone for your assistance.

 

[Rolliee]

To add a record to a table you must use an INSERT QUERY or open the table in VB and add the item(s)


rollie@bwsys.net