Controlling another switchboard

J

Jim L.

We have a training database that opens to a main switchboard. I click on
the option "Search Forms", which opens a second switchboard. From there, I
click "Search by Name", which opens a form with a text box for "First Name",
and another for "Last Name". Once the names are entered, you click a command
button on the same form to "Run the Query". This opens a pop-up form saying
"search complete", and you must click "OK" to make this form disappear, and
continue. You can then click the "View Report" command button on the
original form to get to the report.
The database I am working on has a form with "First Name" & "Last Name"
fields (already filled in), and a command button that opens to the main
switchboard of this training database. Can I add something to my command
button so it automatically selects the above mentioned switchboard options
and enters the names from my form? Maybe a macro that somehow does all of
these steps?
I would ultimately like the user of my database to click the command
button on my form one time to get directly to the report of the other
database automatically using the names from my form. I'm not too good with
code, so please explain in detail if this is even possible.
Thank you all for getting me this far.
Jim
 
W

Wayne-I-M

Hi Jim

The simpelst method would be to run the report in your first DB. Is there a
reason why this can not be done.

If there is a good reason, then one method would be to run an update query
(that updates a table with only that record) with the record you have
selected and then close the 1st DB. Open the 2nd DB and import the table
with the record in it and then run the report.
A good idea would be (after you have run your report or whatever) to deleted
the record from the table - so you are ready to run your upquery again.
 
J

Jim L.

It actually works fine if I just click the switchboard buttons & type in
the names in the training database to see the report. The reason I didn't
want it working this way is because the form in my accident database is used
as a presentation on an overhead projector screen. It kinda disrupts the
flow if the presenter has to stop to click a bunch of buttons & type. It
would be much more professional if all I had to do was click the one button
on the form. I get kinda picky that way sometimes.
As for the update query, you lost me (I told you I wasn't too good at this
stuff). Would this query go in my accident DB & somehow pull all of the
training information for this one person from the training DB table? If
that's the case, it may work fine, I just don't know how to go about doing
it. Can you explain in simple terms?
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top