Query about opening an item in a form from the Switchboard

[Guest]

I've created my own switchboard and one of the buttons on the switchboard
I've asked to open a form in edit mode, the problem is I want it to actually
look for a particular student and open the form in edit mode, can I do this?

 

[Larry Daugherty]

The short answer is "Yes". You created your switchboard so you get to
decide what it will do.

That being said, you need to explain in some detail just how your
:switchboard" is designed in order to get meaningful help. You can
pass a where clause in the code to open a form. Pass in the PK value
of the record you want to open. Switchboards don't usually
accommodate the gathering and passing of parameters so that's where
the explanation is required.

HTH
--
-Larry-
--

I've created my own switchboard and one of the buttons on the switchboard
I've asked to open a form in edit mode, the problem is I want it to actually
look for a particular student and open the form in edit mode, can I

do this?

 

[Guest]

I just setup my switchboard by creating a new one and I have an autoexec
macro that automatically opens it when the DB is opened.

I've then added 2 items just through the switchboard list, one of the items
I added I said to open a form, this is the one I would like to have look up a
particular student and then open it in a form not via a datasheet. I did
write a name search query so that it can prompt you for the students initals
but as I said that takes you to the data sheet not the form, I added this to
the switchboard in design view as a command button that looked at a query.

Monique

 

[Larry Daugherty]

I don't think you can get there from here using the Switchboard
Manager unless you want to do some special tweaking. No way to pass
arguments.

First, I recommend that you get rid of the datasheet view. You can
achieve the same appearance but a much more useful outcome using the
form/subform paradigm, designing the subform down to the point where
it looks like a line of the datasheet view and then displaying it as
"continuous forms".

Second, since you're trying to do something on a specific record how
about creating a form that either allows you to search for that
specific record or that's based on a query that will prompt for the
record identifier? Have the switchboard call that form. Typically
I'd have a combobox in the header of the form that would allow finding
the particular record. If you create a form like that, the Wizard
will help you get the combobox right.

To do a better job of helping you, we'd have to know a lot more about
what it is (in real world terms) that you're trying to accomplish and
then we'd want to know your table structure.

HTH

 

[banty]

The short answer is "Yes". You created your switchboard so you get to
decide what it will do.

That being said, you need to explain in some detail just how your
:switchboard" is designed in order to get meaningful help. You can
pass a where clause in the code to open a form. Pass in the PK value
of the record you want to open. Switchboards don't usually
accommodate the gathering and passing of parameters so that's where
the explanation is required.

HTH
--
-Larry-
--

I've created my own switchboard and one of the buttons on the switchboard
I've asked to open a form in edit mode, the problem is I want it to actually
look for a particular student and open the form in edit mode, can I

do this?