vb and access table

[Guest_imported]

How can I post info from a text box into a cell of an Access table? Iknow how to loop through a collection of text boxes on a form, look for the first empty one and dump info there but how do you do the same on a table e.g. go to field1, field 2 etc until you find an empty cell and insert info?
regards, brian f

 

[2dogs]

The easiest and simplest way to do this would be to:
1 place a DataControl on your form.

2 Set its DataBaseName property to your DataBase.

3 Set its recordsource property to your desired table.

4 In code: assuming table with at least two fields

data1.recordset.movefirst 'move to first record
data1.recordset.edit 'enter edit mode
data1.recordset("field1&quot = text1.text 'fill the first field
data1.recordset("field2&quot = text2.text 'fill the second field
data1.recordset.update 'save this record
You now have a database table with a record containing the data from your two textboxes.


If you would like a small code sample let me know.

Bob Norton
twodog@iprimus.com.au