View Single Post
Old March 29th, 2004, 11:13 AM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

You can not set a parameter in code. Just use an append query in Access, then use a reference to a textbox,combobox, etc. to pass the parametere, or build your string differently. Instead of creating your string like this:

WHERE (((RFQInputSheet.RFQNumber)=[Please enter the RFQ number you want to copy])))

use a reference to your textbox/combobox

".....WHERE (((RFQInputSheet.RFQNumber)=" & combo1.value & ")))"

You get the idea.