connecting two forms

[lee123]

how do link two forms together, i mean if you have a customer form and you have an order form and a access database in the background how do you connect the forms together. i have customers in my customer form and i want to be able to add orders to that customer in a separate form my customer form is using an adodc control for the access database do i need a adodc for the order form as well if so how do i connect these two forms so when i make my data report it will be for that customer.

lee123

[Ali Rizwan]

how do link two forms together, i mean if you have a customer form and you have an order form and a access database in the background how do you connect the forms together. i have customers in my customer form and i want to be able to add orders to that customer in a separate form my customer form is using an adodc control for the access database do i need a adodc for the order form as well if so how do i connect these two forms so when i make my data report it will be for that customer.

lee123

I think you want to add orders directly from customers form and from another form without opening orders form?

You just need to add another adodc in that form where from you want to update that customers data.
Use update command to update that customers data.
Thats it.

For any other problems in such type of database or enhancements or doing some artificial intellignce with your databases contact me. You ll find my email address from my profile. We can chat.
OK
Have a nice day

>> ALI <<