combo box basing

  • Thread starter Thread starter Joshua
  • Start date Start date
J

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
 
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,
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
Click to expand...


.
Click to expand...
 
Back
Top