run multiple fields

  • 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. Now when i double click on the form it on runs the
last field click event and shows the value in that field instead of running
them all in sequence. help
 
Hi Roddy,

Can you post some sample code so we can see what you are trying to acheive,
and possibly why it's going wrong,

TonyT..
 
I HAVE 2 PARAMETERS ON MY FORM WHEN I USE THE CALL STATEMENT ONLY THE LAST
CALL RUNSXXXXXX PASSES BY VALUE NOT BY REF I THINK


Call TOT_PUR_PER_DblClick()
TOT_PUR_PER.SetFocus

Call TOT_PUR_BUS_DblClick()
TOT_PUR_BUS.SetFocus

Call TOT_PUR_BANK_DblClick()
TOT_PUR_BUS.SetFocus

Call TOT_PUR_BROKER_DblClick() XXXXXXX
TOT_PUR_BUS.SetFocus

QUERY FOR 1ST FIELD
stDocName = "TOT PUR PER"
DoCmd.OpenQuery stDocName, acNormal, acEdit

RunCommand acCmdCopy
DoCmd.RunMacro "Macro17"

DoCmd.RunMacro "Macro7"
 
Back
Top