opening a data access page using VB

sparx

Morphed Human
Local time
Today, 01:37
Joined
Jul 22, 2002
Messages
80
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:)
 
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
 

Users who are viewing this thread

Back
Top Bottom