If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How Write New Field Data From Form Entry Into A Separate Table
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? |
#2
|
|||
|
|||
How Write New Field Data From Form Entry Into A Separate Table
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" wrote in message news 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? |
Thread Tools | |
Display Modes | |
|
|