Save data from one fom in several tables

  • Thread starter Thread starter michelle
  • Start date Start date
M

michelle

If I in one form have several textboxes which contain in in ddifferent
tables.
How do I save them, the data, in different tables?

Yhanks for all help
/Michelle
 
You shouldn't need to save in another table, but if you do, you can run an
append query. In code, it might look something like this:

Dim strSQL As String
Dim db As DAO.Database
Set db As CurrentDb

strSQL = "INSERT INTO tblHistory ( ItemID, Subdivision, ModelID) VALUES (" &
Me.txtItemID & ", '" & Me.txtSubdivision & "', " & Me.txtModelID & "');"

db.Execute strSQL
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
I've reduced the data from table 2, i.e all data I want to save
containes in
one table:

I use this command:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

but it doesn't work, what's wrong?
I'm using access 2003.

please help me someone
/Michelle

Arvin Meyer [MVP] skrev:
 
Back
Top