I have a form that is linked to a query. I also have 3 other data input fields that I would like the use to be able to write to another table. My question is how do I link these 3 additonal fields to a table that my form is not based on?
Novice
Windows XP 
Access 2003
I have a form that is linked to a query. I also have 3 other data input fields that I would like the use to be able to write to another table. My question is how do I link these 3 additonal fields to a table that my form is not based on?
Court Jester
Windows XP Access 2003
You dont link them. Have some unbound form controls (textbox, combo box, etc) that the user will fill in. Then you write an INSERT INTO query which will take that data and put it into the table.
how to insert records on some table using data on fields from other table
Posting Permissions
Reply With Quote