Linking Multiple Forms

[Guest]

Help!!! I have several Data Entry forms i am trying to link together. The
first form contains the primary key (loan number) and then some pertinent
data fields that will help my employees ID this file. What I want to do is
after you pull up the correct loan number; I want to be able to switch forms
but remain on the same data file that called-up.

Example: I am on the login form and I enter a loan numner. I would then go
to the borrower infomration form and still be on the same loan number. And
then on to the Financial information for still on the initial loan number.

In fact; the loan number can only change when re-entered on the login form.

You can have my first born if you can help me with this.

 

[Larry Daugherty]

Hi Antoni,

On your original form, place command buttons to open the other forms. In
the Click event of each command button use the Docmd.OpenForm method.
Include a where clause to the effect that the primary key on the other form
be = the primary key on this form.

HTH

 

[Guest]

This did not work. It caused my 2nd form to return NULL results. Any other
ideas? I have seen this work before but for the life of me I can't remember
how it worked.

Thanks!

 

[Larry Daugherty]

I had to assume some reasonable things to give you what I did. The key
assumption, if you'll pardon the pun, is that the primary key of the dataset
is the same throughout. If it's not, you'll have to post back with a lot
more details.about what you're doing.

If they are the same, then, for purposes of test, show your primary key on
your first form. Copy the primary key to the clipboard. Manually open the
next form and it's underlying query. Paste the primary key into the
criteria line for the query on the QBE grid. Run the query. It should give
you the same record as your first form.

Same thing for the third form.

If these test cases work then look carefully at your Docmd.OpenForm line.
Make sure you have the correct number of commas preceding the where clause.
Look in help at the OpenForm method. They used to include an example that
may help although it doesn't cover your case.

If you still have problems, post back with more details of what you're doing
successfully (and how you do it) and what you're trying unsuccessfully to
do. Also, copy and paste your Docmd.OpenForm() statement.

HTH