First time asking a question on Tek-Tips......
Access 2003
Bound Form to table
combobox on bound form with other table as source
on the combobox change event, i need to run an update query so that the pk of the table bound to the combobox updates a field in the table that is bound to the form.
UPDATE MainData INNER JOIN [Processors-Closers-Post-Closers] ON MainData.Processor = [Processors-Closers-Post-Closers].Processor SET MainData.[Processor Log On ID] = [Processors-Closers-Post-Closers]![Log On ID]
WHERE (((MainData.Case)=[forms]![MainData]![CaseID]));
Keeps askimg me to "Enter Parameter Value" any thoughts or ideas?
Access 2003
Bound Form to table
combobox on bound form with other table as source
on the combobox change event, i need to run an update query so that the pk of the table bound to the combobox updates a field in the table that is bound to the form.
UPDATE MainData INNER JOIN [Processors-Closers-Post-Closers] ON MainData.Processor = [Processors-Closers-Post-Closers].Processor SET MainData.[Processor Log On ID] = [Processors-Closers-Post-Closers]![Log On ID]
WHERE (((MainData.Case)=[forms]![MainData]![CaseID]));
Keeps askimg me to "Enter Parameter Value" any thoughts or ideas?