Almost there but, need help with Forms (1 Viewer)

[matt123]

To anyone who can help: I have designed my tables with care, and am ready to make forms for users in my companies database, but here is what I need help with, I need to be able to enter in each field, but when I get to a field which draws from a another table, say Customer, and there is no such Customer, to automatically go to the Customer Form, and force the user to add that Customer, and then bounce back to the order form.
I hope I made sense, and I know its a tall order, I appreciate any help..

 

[Rich]

Isn't it easier to use a form/subform, Customers main form, Orders subform linked by CustomerID.
HTH

 

[Mark Liddle]

Hi Matt
The answer your question lies in the SAMPLES that ships with access.
If my memory serves me correctly, it should be at "C:\Programs\Microsoft Office\Samples"

The same sample of what you are wanting to do is in the NORTHWIND database.)

If the user is adding a new product, but the supplier does not exist in the list, then the "Suppliers" form opens automatically and forces the user to update the supplier details before being able to add the new product.

Hope this will assist you.