Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Onclick of Save button saves data into

Status
Not open for further replies.
dalynching

dalynching

IS-IT--Management
Apr 2, 2003
7
US
the recordsource table, but i also want to insert two fields on this form into another table that is not the recordsource. Any Ideas?

Dalynching
 
Sort by date Sort by votes
try:

currentdb.execute "insert into table (Field1, Field2) values ('" & me.field1 & "', '" & me.field2 & "');"

leave out the single quotes if the data is numeric
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
btamsgn
  • Locked
  • Question
How to edit column chitoi into TableA
Replies
0
Views
154
btamsgn
btamsgn
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
665
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
215
combo
combo
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
529
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top