Update Record only after form is filled out

[Montez659]

This should be a simple solution but it is escaping me at the moment. I am creating a form that a person would use to enter transactions, but I do not want the form to be bound to the table because it is only for inputting new transactions and not for reviewing past transactions.

I was thinking of creating an append query triggered by a command button, but it seems like the only way to append is from table to table (at least all that I read). Can I run an append query from the form or would it be better off just doing it all SQl via VBA (I know you purists would tell me VBA!).

Thanks in advance for any help and links!

 

[alansidman]

Here's a possible solution

http://www.datapigtechnologies.com/flashfiles/addformrecordsnocode.html

Alan

 

[Montez659]

Excellent! That is exactly what I was looking for. A big thank you to you Alan!