S sparx Morphed Human Local time Today, 01:37 Joined Jul 22, 2002 Messages 80 Aug 18, 2003 #1 I would like to open a data access page using VBA code. Is this possible? I would like to open it, when the user inputs the name of the page in a textbox. Thanks for your help Erik
I would like to open a data access page using VBA code. Is this possible? I would like to open it, when the user inputs the name of the page in a textbox. Thanks for your help Erik
IMO Now Known as ___ Local time Today, 06:37 Joined Sep 11, 2002 Messages 723 Aug 18, 2003 #2 Place this code in the 'On Enter' event of the TextBox... Code: Private Sub YourTextBox_Enter() If Me.YourTextBox = "YourPage" Then DoCmd.OpenDataAccessPage "YourDataAccessPage" Else End If End Sub IMO
Place this code in the 'On Enter' event of the TextBox... Code: Private Sub YourTextBox_Enter() If Me.YourTextBox = "YourPage" Then DoCmd.OpenDataAccessPage "YourDataAccessPage" Else End If End Sub IMO