Simulate a mousebutton click on a textbox field

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

Hi All,

I'd like to requery a subform from a button on the mainform, setfocus to
the name fieldon the subform and simulate a mousebutton click, which
executes a series of filters and other commands.

I can requery the subform :), I can set focus to the name field on the
subform :), but I just don't know how to simulate a mousebutton click on
the subform :(

Any ideas greatly appreciated,

Jeff C.
 
JC said:
I'd like to requery a subform from a button on the mainform, setfocus to
the name fieldon the subform and simulate a mousebutton click, which
executes a series of filters and other commands.

I can requery the subform :), I can set focus to the name field on the
subform :), but I just don't know how to simulate a mousebutton click on
the subform :(
Click to expand...


Just call the button's click event procedure using syntax
like:

Me.subform.Form.button_Click
 
Thanks Marshall

I tried your code but it didn't work
I also tried

Me.fmSubEscholha.Form.Requery
Me.fmSubEscholha.Form!Nome.SetFocus
Forms![frmAlunos]![fmSubEscholha].Form.cmdUpdate_Click

No luck.

Any other ideas very welcome,

Jeff C
 
OOps...

Targeted the wrong object and I moved the button to another subform
becuase it's the only place the button needs to be fired from (the
subform changes depending on other criteria. ;(

Should have been:

Forms![frmAlunos]![fmSubEscholha].Form.Nome_Click

Anyway, it still won't fire the onClick event in the subform.

I also tried:

Forms![frmAlunos]![fmSubEscholha].Nome_Click
Me.Parent.[fmSubEscholha].Form.Nome_Click

No luck!

Thanks,

Jeff C
 
JC said:
Targeted the wrong object and I moved the button to another subform
becuase it's the only place the button needs to be fired from (the
subform changes depending on other criteria. ;(

Should have been:

Forms![frmAlunos]![fmSubEscholha].Form.Nome_Click

Anyway, it still won't fire the onClick event in the subform.

I also tried:
Click to expand...
WRONG: Forms![frmAlunos]![fmSubEscholha].Nome_Click
Me.Parent.[fmSubEscholha].Form.Nome_Click
Click to expand...


Make the click event procedure is Public.
 
thanks Marshall,

I Followed your advice and made the function Public and called it.
It works great.
Appreciate the help,

Jeff C.

Marshall said:
JC said:
Targeted the wrong object and I moved the button to another subform
becuase it's the only place the button needs to be fired from (the
subform changes depending on other criteria. ;(

Should have been:

Forms![frmAlunos]![fmSubEscholha].Form.Nome_Click

Anyway, it still won't fire the onClick event in the subform.

I also tried:
Click to expand...

WRONG: Forms![frmAlunos]![fmSubEscholha].Nome_Click
Me.Parent.[fmSubEscholha].Form.Nome_Click
Click to expand...



Make the click event procedure is Public.
Click to expand...
 
Back
Top