Opening Page In Tab

[abbaddon223]

Hi all,

I'm having a VBA nightmare for what I imagine is a simple fix.

I have a page in a tab (in a form) called "Contact Screen".

Following a combo box being updated on another page in the same tab ("Outcomes") I'd like the "Contact Screen" page to open (come to the front).

I've been trying along the lines of (after update obviously)

Docmd.openform "FormName!PageName"
docmd.OpenForm "FormName!PageNumber"

I'm getting nowhere are could do with a little help please!

Thanks in advance

 

[vbaInet]

SetFocus to that page.

 

[abbaddon223]

I may kill myself for that!! Thanks so much!!

 

[vbaInet]

I may kill myself for that!!

You will need an accomplice

You're welcome!