run multipe fields for queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
when i use call only the last field runs with its value the first six do not
execute at all
 
Back
Top