Same AutoNumber on two different forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I've been racking my brain with this problem for two days. I need help.

I have a main input form called DMR. The indentification numbers assigned to
each DMR are simply AutoNumbers (which are also the primary key). I have
another form called CAR. I want the same AutoNumber that is on the DMR form
to be on the CAR form. In other words the AutoNumber on the DMR form will be
the reference number on both forms.

Can anyone help?
Thanks,
Kat
 
Kat,

Hi from the UK!

I guess that while the autonumber is the key field on the table behind one
form, then EITHER the other form shows different fields from the same table
OR the other table shows data from another table linked to that field.

Do you keep both forms open at the same time? If you do, then you could set
up the data for 'form 2' from a query where you set up the criteria for the
linked field as

=forms!DMRForm!KeyFieldname

(substituting the actual form & control names of course!)

If you have a search process on 'form2' you'll need to modify that so it
actually changes the record shown on the 'DMRform' (which will then force
'form2' to show that record).

As a slightly more 'out of left field' solution you might consider - if it's
appropriate - putting th contents of both forms onto two 'tabbed pages' of a
tabbed control. With current workstations having decent amounts of RAM to
hold large quantities of data it makes moving from one part of the database
to another much easier.

Any help?

All the best!
 
Hi Laury!

Thanks for your help! I have a couple more questions please.

The way the whole database works is - they input data into the DMR form and
then they have an opition to choose (with command buttons) either of 3
different forms. Whichever one of the 3 forms they pick, from then on that
form has to be connected to the original DMR. Put then I have to be able to
print (on a report) information from BOTH forms.

Do you still think tabs are the best way to go? Can you make a report from
two different tabs combining the information? I've never used tabs before so
it will be a real learning process!

Thanks,
Kat
 
Kat,

I hope these comments will be helpful to you. I feel you will find it
easier to work with this database if you remember a few things. Forms
don't have data. Data is in tables. Forms can provide an avenue for
accessing the data in the tables, and an interface for the
entry/editing/viewing of the data that is in the tables, but ultimately
the form does not have data. Similarly, a report can not print data
from a form or forms. A report prints data from a table, in most cases
based on a query which is based on the table(s). So, when you are
trying to figure out questions such as those you have asked, it is
usually easiest if you think about the data you are working with. In
this case, for example, I would assume that the first form is based on a
table, and the other three forms are based on another table, which has a
one-to-many relationship with the first table... am I right? If so,
then the 3 secondary forms may need to be placed on the main form as
subforms?
 
Hi Steve,

Thanks so much for your help! Your comments are very helpful as I had not
thought my whole process out. I went with the tabs that Laury suggested and I
am getting the exact results I want! And, I put the results in the reports
that I need.

I appreciate you getting back to me and helping me to understand the process
a little better!

Kat
 
Back
Top