Linking Subforms using the Auto Number

I

idontgetit

First question - is it possible to link a subform to a form using an auto
number?

Here's what I'm doing...
I have one table called Claim Number which has a claim #, date and location.
Which I have an auto number on the claim number, format /2000 so that it
will start at 2000.
I have another table that stores the information that is getting claimed. I
reference the claim number in this table and set it as a number.

I made a form for both of these tables and want to use the information table
as the subform on the Claim Number Form. I entered the relationship b/w the
two forms as the claim number.
I can enter the information, but it doesn't stay in the form. It stores in
the table, but I would like it to show in the forms so that if I need to make
changes i can.

Thank you very much for your help!
As you can tell, I'm new to this.
 
B

BabyATX13 via AccessMonster.com

idontgetit said:
First question - is it possible to link a subform to a form using an auto
number? Yes

Here's what I'm doing...
I have one table called Claim Number which has a claim #, date and location.
Which I have an auto number on the claim number, format /2000 so that it
will start at 2000.
I have another table that stores the information that is getting claimed. I
reference the claim number in this table and set it as a number.
Click to expand...

In your form select the subform and in properties link the child and master
fields.
KB
 
Top