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?

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

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"SteveL5231" <SteveL5231@discussions.microsoft.com> wrote in message 
news:DC4AD5F3-CA7D-46C8-9CD7-763421F8045A@microsoft.com...
> 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?