run multipe fields for queries

[Guest]

I have a subform with 7 fields that when i double click each one it runs a
query that puts a value into that field (each field has a different query).
I would like to be able to double click on the subform to run or activate
each field in sequence. Nowwhen i double click on the form it only runs the
last field click event and shows the value in that field instead of
activatine all the fields in sequence

 

[Guest]

Private Form_DblClick()
Call fldOne_Click()
Call fldTwo_Click()
etc.
End Sub

Substitute the actual names of your controls for fldOne, fldTwo etc.
Depeding on the nature of your controls, you may need to precede each Call
with fldXX.SetFocus

 

[Guest]

when i use call only the last field runs with its value the first six do not
execute at all