Sure hope I'm not posting this in the wrong place. :o
New to this forum but not Access. Been using it for some time but still have lots of questions. Currently using Office 2007 on Windows 7. Looks like some bright people here and I'm glad to make your acquaintance.
Try using this on the form's open event:
DoCmd.OpenForm "YourFormName"
Forms![YourFormName].TabCtl104.Value = 1
Only you know the TabCtl(yourtablname) (check the name on the properties sheet)
You can then determine if it's = to 1, or 2 or 3, depending on what tab you want to see when it...
I have searched out this question for 2 days. Lots of examples that work for people but still fail when I use them. I have a basic un-understanding of objects. I need to manipulate an Excel spreadsheet to delete the str value cells (""). I am getting sooooo frustrated. Below is code I'm using...