I am trying to make up a Database that we can enter data on Licensing of different products we have here. I want to keep track of the Dates the Licenses need to be renewed.

So what I have made so far.

IS 2 tables One I have called Customers in here I have all the info I need.
The other Table I called VL Info. This is where I want all the License Numbers, Product, and Expire Dates.

In the Form I have all the stuff to fill in. I want to add in this form the Info for the License stuff. I added a SubForm and picked the VL INFO Table.
So here is what I get.
I get the look I want, it shows the info from that VL Info.
But when I click on the main page to go to the next record, the VL info stays the same. Am I not linking something correctly?
When I go to record 2 I would like it to be blank or be what it would be assigned to Record 2.

Hope this make sense....

Maybe I am looking to do something else.
The Sub Form I can enter stuff in now. But it disappears.
So say if I went to the Main Record and put in another Subform item. It stays until you change the Main Record.
It keeps all the info in the Table but doesnt show it on the screen.
Maybe that is what your talking about with the Continuous Forms?

I will attach the newest update.

What I am wondering how to do is.
Either to make a Report or Queries.

I want to be able to put in a range for the dates. So in the Form I might have the Expiration date Feb 2007.

In a Report I might want to say Dates between November 2006 and March 2007.
It would bring up the dates between these in a report that would list all the infomation.

Here it is with the links made between the 2 forms.
Your subform would be more versatile in the future if you made it "Continuous Forms" rather than Datasheet.

Ok I think I got it going now How I would want it.
It seems to work.

So Thanks for you help.

Wondering if you can take one look at this and let me know how to fix the Subform Look.
I want the subform look to look like the top Form.
I didnt want it looking like the table look.
But it keeps going that way .

Ok here is what I have so far.
Its just basic and just starting off.
I am not concerned about the look yet.
Its just getting that SubForm to change to the next record.

Sounds good.
I will look for that one your creating.

Thanks again for all your help.

Got it working.
I think I am on my way now.