combo box basing

[Joshua]

Hello,
I have a field called 'contracts ID' and
some 'products' each for every contract. I want to create
a combo box with a list of contracts and when a particular
contract is selected, I want a combo box to show the list
of products for the contract ID selected.

Thanks for any help. Please consider the fact that I am
new to Access!!

Joshua

 

[AlCamp]

Joshua,
Use the value of [Contract ID] to filter the records returned by your
Products combo box.
In the query behind your Products combo, in the [Contract ID] field, use
a criteria of...
= Me.[Contract ID]
to filter the records returned... to only those Products that have a
[Contract ID] = to what's in the [Contract ID] field on the form.
hth
Al Camp

 

[Ken Snell [MVP]]

See this article at The ACCESS Web to see how to tie the two combo boxes
together:
http://www.mvps.org/access/forms/frm0028.htm

 

[Joshua]

Hello,
Thanks first for the suggestion...I treid it..but, the
problem is, there are many Products for a single COntract
ID and when I select the Contract ID, the Products combo
box shows only one product many times.
Any idea how to solve this!!!

-----Original Message-----
Joshua,
Use the value of [Contract ID] to filter the records returned by your
Products combo box.
In the query behind your Products combo, in the [Contract ID] field, use
a criteria of...
= Me.[Contract ID]
to filter the records returned... to only those Products that have a
[Contract ID] = to what's in the [Contract ID] field on the form.
hth
Al Camp

Hello,
I have a field called 'contracts ID' and
some 'products' each for every contract. I want to create
a combo box with a list of contracts and when a particular
contract is selected, I want a combo box to show the list
of products for the contract ID selected.

Thanks for any help. Please consider the fact that I am
new to Access!!

Joshua

.