Switchboard option identification

message from =?Utf-8?B?THlu?= on 11 May 2004
I have three Switchboards containing a MAIN Menu, and ENTRY Menu and an EDIT Menu.
Before I enter further data on a subject the first action is to open a form to enter the subject ID to check that the subject does exist in the database, then depending on what option had been selected, say for example the option to enter a follow-up, I would then wish to open the form for entering follow-up data, or if it was an Adverse Event I would wish to open the Adverse Event form.
I therefore need to be able to determine which option had been selected on the ENTRY Menu Switchboard to determine which form should be opened. Is there a way of capturing the ItemNumber or OptionNumber or something.
Any suggestions on how I can do this?
Thanks
Lyn
 
=?Utf-8?B?Q29ycmluYQ==?= replied to =?Utf-8?B?THlu?= on 11 May 2004
The switchboard is really useful for quickly setting up menus to get to different parts of your database, but for the level of automationn it sounds like you want to do, I think you are better off creating an unbound form (that you can open from the switchboard).

From your description, some things you might want to include on the unbound form are a combo box of subjects, a button that opens a form to add new subjects, and buttons to open Follow-Up Data, Adverse Event, and other forms for that subject. You can use visual basic to set the defaults of the forms to the subject selected in the combo box.

I hope this gives you some direction in how to do what you are trying to do.

Corrina Burnley
Burnley Data Solutions
www.burnleydatasolutions.com
 

Archived message: Switchboard option identification (Microsoft Access Error Message)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.