run multiple fields

[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

 

[Guest]

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..

 

[Guest]

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"