I don't know about the VBA , but if you go into your design view and then to the Properties of the Sheet Their is an Option whereby you can go to the ScrollBar menu on the "ALL" Tab and then turn it "Off" so that it doesn't show at all in your Formview. I am not sure if that is what you requested , but I have done that numerous times to ensure that the Employees don't see the Scroll Bars

I have created switcboard. One of my Buttons are linked to a Macro that opens a Query with a Criteria option whereby they have to put The Employee Code in to view the information they require.
What I want to do is to (instead of seeing Option to ENTER EMPLOYEE CODE
I want a List of All Employee codes to be displayed and then when they select a specific Employee code it opens the form

How do I get that List displayed...

Thanks A Lot I Did BOTH suggestions and It Is Now Working

I have created a Database in Access 2003 and have now downloaded 2007. I have tried converting it in several ways. I have opened my previous Database and saved it as a 2007 verion -No success, I have created a Blank 2007 DB and imported all the table , Queries , Forms Reports and Macros from the previous version. Although I can see all - The switchboard which is suppose to open immediately only opens with No information. I can only see my Background...