Is this possible please?

[ignite]

Hello,

I have an order form where I want when you type in the Customers number their details (i.e. address) are then displayed on the right hand side of the form. I have basically two tables linked, an order table (OrderID, CustomerNumber) and a customer table (CustomerNumber...and their personal details).

Does this make sense? Is this possible, perhaps with VB, or would I use a query?

Thanks for any help given

 

[atisz]

Maybe this is

I don't know if I understood what you want, but if I did, then you have to make a form for your Customer table and then insert it as a subform on your Orders form. This way you can set up a link based on customer number, and after writing the customer nr in the order form's custumer nr field and jumping to the next field, in your subform the customer related details will appear. Is this what you need? I hope so.

 

[maxmangion]

check this sample