LOOPING 3rd REQUEST

C

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
 
J

JAT

Going to basics, is the recordset from the query
updateable? or does it contain restricted joins?

JAT.
 
C

Chris B

UPDATEable, I can type any change I want on the form, I
just can't update it with code!

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updated Request 1
Setting Field values in a For Next Loop 5
Hiding controls based on number of questions 4
VBA Multiple Line handling with Split() 1
Append Query problem 2
Looping through controls on form and subforms to return control la 3
Looping through a recordset 1
Looping through Records 6

Top