Subform needs to change info depending on what customer is selected

[Marissa via AccessMonster.com]

I have a data entry form that lets you enter your cust info and includes two sub forms. Subform 1 lets you enter products *only* for sale to that specific cust. Subform 2 lets you enter the sales people who will get the commission off the sale. (Everything is connected correctly w/ master & child fields) For every sale, all sales people for that cust get the commission (usually 2 or 3).

My prob is this: I am now creating my order form. I have a combo box that lets you select the cust and brings in all the info. My subform (where I enter the sale) has a combo box that lets you select what product the cust is buying. I need a way to do the following:

1) Make the products listed in the combo box change depending on which cust has been selected

2) Have the correct salespeople's info come in so they get the correct commission

Any help would be EXTREMELY appreciated!

THANK YOU!!!

 

[lopi]

"Marissa via AccessMonster.com" <[email protected]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:

I have a data entry form that lets you enter your cust info and includes

two sub forms. Subform 1 lets you enter products *only* for sale to that
specific cust. Subform 2 lets you enter the sales people who will get the
commission off the sale. (Everything is connected correctly w/ master &
child fields) For every sale, all sales people for that cust get the
commission (usually 2 or 3).

My prob is this: I am now creating my order form. I have a combo box

that lets you select the cust and brings in all the info. My subform (where
I enter the sale) has a combo box that lets you select what product the cust
is buying. I need a way to do the following:

 

[Marissa via AccessMonster.com]

Sorry, unsure as to what that means...

 

[John Vinson]

I have a data entry form that lets you enter your cust info and includes two sub forms. Subform 1 lets you enter products *only* for sale to that specific cust. Subform 2 lets you enter the sales people who will get the commission off the sale. (Everything is connected correctly w/ master & child fields) For every sale, all sales people for that cust get the commission (usually 2 or 3).

My prob is this: I am now creating my order form. I have a combo box that lets you select the cust and brings in all the info. My subform (where I enter the sale) has a combo box that lets you select what product the cust is buying. I need a way to do the following:

1) Make the products listed in the combo box change depending on which cust has been selected

2) Have the correct salespeople's info come in so they get the correct commission

Any help would be EXTREMELY appreciated!

THANK YOU!!!

Lopi is a spammer, ignore that message. <snarl>

Please talk to the administrators at AccessMonster and ask them if
they can word-wrap messages. It's a pain to have to scroll over four
screens to see your question!

That said:

The products combo box can be made to depend on the customer combo box
by changing its Rowsource query dynamically, based on the selection in
the customer combo box. There is sample code at

http://www.mvps.org/access/forms/frm0028.htm

There is no need to copy information from the sales people table into
the second subform; all you need is the salesperson's ID. You can
create a Query linking that table with the personnel table to pick up
their information.

John W. Vinson[MVP]

 

[Marissa Hoffman via AccessMonster.com]

Great - thank you very much!