Updated Request

[Chris B]

Yesterday, I asked for help on assigning values to fields
contained in a loop. The responce was the following:

For x = 1 to 10
Me.Controls("PACS_QE" & x) = 0
Next

This works when I run it against a table but not a joined
query. Anyone please help explain why or how to fix the
problem.


Chris

 

[Kelvin]

You cannot update a joined query since these are uneditable. Need more info
in order to describe how to perform the update. But the main point is that
if you are updating through a bound form, the source has to be editable (a
table or an unjoined query).

Kelvin