I have been trying for 2 days to resolve this problem, the objective is to search for a Serial # on a Sub-form, that is on a tabbed page, on a Customer's form. I am guessing that the answer would be complicated, so I have tried to help by including the names of each form, control etc that is shown in properties.
From my 'Home' screen, I have a combo box (simply called 'SearchSerial#') where I can list items sold and their unique Serial #, I need to select a Serial # then (from the After Update function) a Macro runs the following:
1) Opens the form, 'Customer Details' where there are 3 tabbed pages, 'Detail', 'History', and 'Orders' that is part of a cluster called 'tabContacts'.
2) Navigates to the 'Orders' tabbed page (in properties this page is called 'Orders_page' and tab index is 2), on this tabbed page there are 2 Sub-forms, 'Order' and 'Order Details'.
3) Navigates to the 'Order Details' Sub-form and then to the 'Serial #' Control, and finds the Serial # that I chose in the combo box.
Firstly, is this all possible? I know it's complicated but, without having to re-organise the forms and sub-forms that already work very well, it's what I need to fix.
If it is possible and someone can help, they must be either a god, or a genius, and will have my everlasting envy and thanks.
P.