form jumps around when using GoToControl

[callipygous]

Hi there,

Im using Access 2000, DAO database app.

I have VBA code under some command button that does

cmdResident2.Enabled = False
DoCmd.GoToControl "apparent_cause"
cmdToControl.Enabled = False
cmdYesOtherPerson.Enabled = True

on the GoToControl part the form repositions itself so that "apparent_cause" is at the bottom, looks really confusing and bad - is there a way out of this?

So that you press the button and the curser just appears at the control without the form moving? (they are both on the same tab page of the same form)

Thanks
Callipygous

 

[PaulF]

try using Set Focus instead of GoToControl

Me.apparent_cause.SetFocus

PaulF

 

[callipygous]

PaulF, Thanks for replying

Yes it still jumps - i think its cos the form is quite large size (A4 just) because they don't jump when the form fits all on one screen.

im not sure how to tell the form to remain fixed and just swap between controls?

Thanks
Callipygous