Update query not working when called from a form

  • Thread starter Thread starter Pete Halasovski
  • Start date Start date
P

Pete Halasovski

Hi,

I've got a problem automating the update of a field via a form. I have a
table with two fields, I'm trying to set up a form with a combo box that
causes two different fields to change. What I have tried is this:

Create a Combo box which updates the first field, on the On Change property
of the combo it calls a macro.

The macro calls an update query which updates the second field.

The query identifies which record to change by a unique ID. However when the
form execute the macro the underlying update query pops up a "What is the
unique ID?" box. If I run the update query manually it works fine.
ARRGGHH!!!

I know it's something £$%^&* obvious but it's eluding me at the moment. Any
ideas?

TIA,

Pete
 
Hi Arvin,

Thanks for the reply.

Tried that: Requery the table (which saves the form) then open the Update
query. It still asks for the value that is sitting in the Combo box. Arg.

Pete
 
Back
Top