Prev: change textbox to checkbox
Next: Split Form in Subform or same effect 2 subforms
From: SteveL5231 on 3 Apr 2010 08:29
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?
From: Allen Browne on 3 Apr 2010 09:51
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(a)discussions.microsoft.com> wrote in message
news:DC4AD5F3-CA7D-46C8-9CD7-763421F8045A(a)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?

 | 
Pages: 1
Prev: change textbox to checkbox
Next: Split Form in Subform or same effect 2 subforms