How Write New Field Data From Form Entry Into A Separate Table

[SteveL5231]

I have a form which contains a listbox. When the user double-clicks on the
listbox a 2nd form opens and the user can make a new record entry. On this
2nd form is a field named "txtChillN". When the user has made the entry into
this 2nd form I want the value of "txtChillN" to be entered into an unbound
table named "tblChills". The field name in this table is "ChillN'. How do
I do this?

 

[Allen Browne]

Simplest solution would be to Execute an Append query statement.

You can mock up a query using any old value for the insert. Then switch the
query to SQL view to see an example of the string you need to use in your
VBA code.

For sample code, see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html