Form + tab ctl + sub form - go to specific record

[mcclunyboy]

Hi,

I have a Dashboard (sort of), a home page with a couple of sub-forms to display data to users easily. One of these dashboards is a list of incomplete invoices, I would like the user to be able to click a button on each of the sub-form (continuous form) rows. This button will then take the user to another tab (3) which contains the main invoice screen within in a sub-form. This screen should jump to the specific record the user click upon in the original sub-form....

So:
1- user logs in
2 - user selects invoice in home screen sub-form
3 - db switchs tab, (jumps to another sub-form)
4 - focus set to specific record.

Ok I know the following:

-> Jump to tab

Forms!Form1.TabCtl0 = 3

-> Set focus on form

Me.sub-form.Form.txt_invoice_id.SetFocus

 

[jdraw]

Dashes (-) are likely problem in Access.

 

[mcclunyboy]

Dashes (-) are likely problem in Access.

apologies, the forms aren't actually using dashes, they all use underscores