insert data into another table after saving the current form.

A

apro

h
i am not able to insert data form currrent form into another table
i have a primary key field customer no in current form, which is generated automatically and i want the same value to be inserted in to another table: orders, which has same field and and is of same data type
i used insert command, and DoCmd.RunSQL comman
Insert Into table(feild) values (forms!feild.value
o
even if i assign a variable to a numbe
and use it insted of (forms!feild.value
it does not work, it asks for user to input parameter

please help me
thank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I clear a form? 0
Inserting information to a table on form close 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Insert Into 2 tables from a form & subform 1
Data entry for a table from a form 1
filtering a form based on a filter on an open form 1
Copying record to another table 2
Help needed passing data from the form to a table. 0

Top