transfering data from a query to table

[jbm]

i have a query with this information: Project Id, Project description, Partnumber id,and part number description. there may be 4 or five items with the same partnumber. I would like to select the proper project and have that added to a new record in a different table.<br>&nbsp;

 

[rbowes]

Sounds like the best way to do this is to make your query into an append query and place a parameter into the criteria of the Project ID field.&nbsp;&nbsp;I would create a form and have it the user choose the Project ID - all information would appear,&nbsp;&nbsp;project ID , Project Description, PartNumberID and PartDescription.&nbsp;&nbsp;Create a command button and on the onClick event put:<br><br>if IsNull(me.projectID)= false then<br>&nbsp;&nbsp;&nbsp;DoCmd.OpenQuery &quot;qryAppendProjectID&quot;<br>Else<br>&nbsp;&nbsp;&nbsp;&nbsp;MsgBox &quot;Sorry, You did not enter a valid ProjectID&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;exit Sub<br>End if<br><br>In your query, in the criteria row of Project ID type:Forms![MyForm]![ProjectID]<br><br>Let me know if this works for you.<br><br>Bob B.<br>