Master form with combobox selection

[iamdamien]

Hi,
I am relatively new to Access. I have created a master form or main menu, from which I want to go to all other forms from. I want to do this by having a combobox rather than 5 or 6 buttons if possible. The user will select their form choice and press a navigation button to access that particular form.
How would I go about doing that? I am using Access 2007 and the open form wizard is very helpful, I would just much prefer a nice neat combobox method.
Thanks.
D.

 

[DCrake]

You might be better using a listbox than a combo box. A combo box can get a little bit iscolated whereas a list box can be more intuative and the user has less mouse clicks to perform.

Create a table that has two fields

FrmName
FrmAccessName

FrmName contains the name of the form to open that is user friendly
FrmAccessNam is the actual name of the form

TblFormNames
FrmName "Contractrors Directory"
FrmAccessName "FrmContractors"

Use this tabe as the row source for the listbox

LstForms
RowSource "Select FrmName, FrmAccessName from TblFormNames Order By FrmName"

Columns 2
Column Widths 4cm,0cm
Bound Column 2

On DoubleClick
DoCmd.OpenForm Me.LstForms.Column(1)


By using the double click event you do not need a further button to open the desired form.

 

[iamdamien]

Thanks for the reply. So the table refers to the forms I wish to open and the listbox allows the user to double click and open their form of choice? If so that is just as good. But will the listbox method allow me to separate table options? For instance, report forms, adding record forms and editing record forms? Or will the user have all these options directly from one single listbox?

 

[DCrake]

That is all down to how you want to construct your menu system.

 

[iamdamien]

I have done the method as above, and there is a compiler error stating that .LstForms is not found to be a method. I think this may be because the the method is created by a wizard with the same arguments. Should I just go into the event procedure menu and insert the RowSource method you posted?

 

[DCrake]

LstForms is the name of the list box on your form

RowSource "Select FrmName, FrmAccessName from TblFormNames Order By FrmName"

Was an example of using SQL in the rowsource property of the list box

 

[iamdamien]

Thanks for the help. I realised the error I had made. I misunderstood what you were showing me to do. Thanks for the help. Very much appreciated!