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

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.


-- 
Wayne
Manchester, England.



"Jim L." wrote:

>   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

  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

"Wayne-I-M" wrote:

> 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.
> 
> 
> -- 
> Wayne
> Manchester, England.
> 
> 
> 
> "Jim L." wrote:
> 
> >   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