Update table

[IanT]

I have a form which has variables I wish to append to a table. What is the best way to achieve this. Would it be a SQL stsatement or is there another way as there is no reference to table data!

 

[KeithIT]

You should use an append query. You can either set up the query in Access and reference it in VB, or if you are only using the query once or twice then just write out the sql statement in VB and go that route.

If you are going to use this query on a regular or fairly regular basis it makes much more sense to build the query in access and store it and then call it whenever necessary. You can always use VB to change the parameters of the query if you need to tweak it for various functions.

If you wanted to use just VB you could search the forum for any posts on updating records and ADO or DAO recordsets, depending on which version of Access you are using.