Adding an entry from form to table

[p4nny]

Hi

With the click of command button, I would like to insert the value on a form (textbox) to a defined table.

The textbox has an expression within it.

please could you provide the most direct way of doing this whether it by SQL or VBA?

Your help is greatly appreciated.


text box on form is called tbFullName
Field on table is called L1 Reviewer
Form is called LC1 Input Tracker

Command Button is called Add Record

[alansidman]

If your form is bound to the table, then there is no need to save/add the record. That occurs automatically in Access when you either close the form or move to a new record. If you have an unbound form then you will need to use a different method. Look at this video if that is the case.

www(dot)datapigtechnologies.com/flashfiles/addformrecordsnocode.html