I have a file index database. I have a form with a tab control on it with each page representing additional fields tied to different types of files. For example, "claims" is the first page with unique fields specific to Claims, the second page is "collections" with it's own specific fields.
Is there any way to have the respective page within the tab control become visible when the FileType field is entered or changed. So if a user is opening a "collection", the "collection" page will become visible, but if they open a "claim", the "claim" page will become visible (without going into the tab control).
I assume there is some VBA code that could be entered in the "OnChange" or "OnExit" property for the FileType field. I want to use this as a way to guide the user on the information that needs to be entered based on the type of file they are opening.
Thank you for any ideas !
Is there any way to have the respective page within the tab control become visible when the FileType field is entered or changed. So if a user is opening a "collection", the "collection" page will become visible, but if they open a "claim", the "claim" page will become visible (without going into the tab control).
I assume there is some VBA code that could be entered in the "OnChange" or "OnExit" property for the FileType field. I want to use this as a way to guide the user on the information that needs to be entered based on the type of file they are opening.
Thank you for any ideas !
