Form + tab ctl + sub form - go to specific record (1 Viewer)

mcclunyboy

Registered User.
Local time
Today, 08:06
Joined
Sep 8, 2009
Messages
292
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
Code:
Forms!Form1.TabCtl0 = 3

-> Set focus on form
Code:
Me.sub-form.Form.txt_invoice_id.SetFocus
 

jdraw

Super Moderator
Staff member
Local time
Today, 11:06
Joined
Jan 23, 2006
Messages
15,364
Dashes (-) are likely problem in Access.
 

mcclunyboy

Registered User.
Local time
Today, 08:06
Joined
Sep 8, 2009
Messages
292
Dashes (-) are likely problem in Access.

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

Users who are viewing this thread

Top Bottom