b]Adding a new record via a query....[/b]

[Radman]

I want to add a new record to a table, but i have the user, useing a query to find the record that the want to add to.This is because i have details from other tables appearing on the screen too and the table which they are to be added to is in a sub form.&nbsp;&nbsp;&nbsp;m - 1 <br><br>i have tired just adding a new rec but it needs the id of the foriegn key b/c of ref integrity<br><br>Can this be done this way (at all this way)?

 

[DougP]

Not sure exactly what you want.<br>Is it to know how to add a record to a subform and give it the Id from the main form???