putting data in one form and showing it in another

[KRob]

I am very new at this so bear with me!



I am pretty far in designing my database. I have a form that I enter client address and product information. I created another form for that information and to add more (like a client that uses a certain product and then switches to another product, I want to keep track of all items used by the client).

The problem I am having is when I add a new client the information on the new client form it does not transfer to the multiple purchases form. It does with the clients I pulled in from Excel, for those clients everything is working fine.

I tried to work with the relationships between the two tables (client information and client products). I just can't figure out why new clients are not being pulled up in the multiple purchases form.

Any suggestions?

[June7]

Have to do data entry into the purchases form.

Are you using form/subform arrangement?

If you want to provide db for analysis, follow instructions at bottom of my post.