I have a VB App that connects to a Microsoft Access Database using DAO. When a user opens the VB App, they have to sign in using a username and password. The username is a textbox on frmlogin. I want this value to be passed to a Data Access Page, so that when the user open the Data Access Page, it will automatically send their username as a parameter in my query. My VB App opens the DAP buy using the shellexecute command. I know how to pass the value from the DAP to my query, however I do not know how to pass the value to the DAP. Is there any way to do this? If you need more information on my VB App or the Database, please let me know.

Thank you in advance for any suggestions.

Jona