Open report in another DB

J

Jim L.

I have a form with a command button that opens to the switchboard of another
database, which works fine. Is there a way to pre-select the switchboard
items of the other DB so all of the work is done when the user clicks on my
command button?
If so, I have another problem. My form has a text box with a name field
formatted as "Last, First". The other DB has a form with a text box
requesting the user to enter the last name, then another one for the first
name in order to fulfill the query parameters that the report is based on.
How can I break my name field up into a last name box and a first name box,
and then have those values displayed on the form of the other DB?
I'm quite lame when it comes to coding, so simple in-depth explanations are
appreciated.
 

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