Dropping unbound fields into a new table

[BrettECV]

I'm new to this Access stuff and I'm playing about with a database at the moment to track training that is taking place in the workplace... Currently I have a new form (completely unbound) and now I'm trying to write the values to a temp table to then run an append query off.. The problem I'm having is taking some of the calculated data from the form and placing it into the new table.. I might be trying the impossible but hoping someone can help.

Brett

 

[alr0]

Hi Brett,

Open a recoreset in VBA code (see open recordset in help) and you can make any assignments to the table that you like from the form controls or anything else you can do in code.

Hope this is a good start,

alr

 

[alr0]

Hi Brett,

Open the table as a recoreset in VBA code (see open recordset in help) and you can make any assignments to the table that you like from the form controls or anything else you can do in code.

Hope this is a good start,

alr

PS form

Dim rsMyRecordset As Recordset
Set rsMyRecordset= New Recordset
rsMyRecordset.Open "select * from tblTableName",_ CurrentProject.Connection, adOpenDynamic, adLockOptimistic

 

[BrettECV]

Thanks.. It seems like a good start.. I found a website : -

http://www.comeandread.com/access/

had a heap of ideas and some sample code re: extracting data from an unbound form..
Thanks to all who replied and thosewho scratched the brain to try..

Brett