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!

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

Inputing data into 2 tables.

Status
Not open for further replies.

erik71

MIS
Aug 13, 2001
2
US
I'm trying to figure out how to input data from one form into two seperate tables. Can I or do I need to create a subform?
 
erik71,
try just filling the tables using a couple of runsql commands such as
DoCmd.RunSQL "INSERT INTO tblName (FieldA, FieldB, etc.) VALUES ('" & FieldA & "', FieldB, etc.);"
Just a suggestion, but it might work...
Dave

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top