Post to Log File

[rfhall50]

I have a pretty straight forward situation. Basic visitor login scenario.

My form validates info in an existing table (visitor names) and has another unbound field for input (destination). When all fields are complete, user will press a button to add the record to the log table (there in my problem). Total fields used is 4 (date, time, info from input table, unbound field from form). When rec is written to the log/arch table, the cycle starts back over.

I know this could be done writing to a flat file, but will need to do reporting on it later.

What is the simplest method to log/archive these transactions to a table for later process/reporting. (I am comfortable using VBA, just real sketchy on the many different DB formats).

Thanks you very much.

Bobby

[PEB]

Hi Bobby,

In fact what is the problem to not write directly to your log table? All the fields aren't filled in?

[rfhall50]

Thanks for the reply. I understand assigning the values to the table. The problem is that I don't know how to code a query or SQL. I do know how to update the current table attached to the current form, but it's adding a new record in a totally different table that I don't understand.

Anything you can offer is appreciated !

Thanks again,

Bobby