Form design in access

[sindhuja]

:doh:
Hi All,

I need to design a home page for my project am doing using MS Access.
The lists tat i have should be displayed the same way as the vba express menu listing...

Something like a label, if i place the cursor over the label it should display the list of forms under the selection..

Can anyone help me out in this....

-Sindhuja

[CreganTur]

When you say 'home page' are you talking about a Data Access Page, or are you talking about building a Form?

[sindhuja]

Hi,

Once i login , homepage will be the form...
there i will be having many options like the beloe one...

Data
-Customer
-Supplier

Reports
-Morning
-Evening

Checks
-Sanity
-Deadlines

Under "data", customer and the supplier are the two foms from which i choose either... similarly for other cases...

If i place the cursor on Data it should give the options...

Hope this is clear..
Please help me out in designing a form like this...

-Sindhuja

[CreganTur]

Honestly, the only way I can think of doing anything even close to what you're asking is by using comboboxes on the form. I would suggest placing a 'Go' button next the combobox and put this code behind it:

Dim cboName As String

cboName = Me.ComboBox '<<<change to name of combobox

DoCmd.Close '<<<Close current Form
DoCmd.OpenForm cboName '<<<Open form with name selected from combobox