enter data in table using VBA

[Derkins]

Hi guys,

Im trying to 'force' data into a table with an after update sub on my combo box. I need to code it so that it will look up a record in my table base on certain criteria, and insert the combo box selection into a certain feild within that record.

I have looked into FindFirst, opentable, etc. Im not sure which direction to go in as i have no been successful with any of them.

thanks for the help guys

 

[pbaldy]

I'm not clear on the question, but the 2 basic ways to add data to a table from VBA are the AddNew method of a recordset (DAO or ADO) or executing SQL:

CurrentDb.Execute "INSERT INTO..."