S
samantha
Hello,
I have a complicated problem.
I have a form that displays various details about a
product during different dates. I have a combo box where
the user can select a particular date he wants to see the
details for. The he has to select a contract from the list
of contract IDs available for that date. Then has to
select a product in the contract and he sees the details
for the product in the partcular contract in a particular
date.
I have a table that contains all the details i need to
display in the form. I have an append query, which adds
new records to the table everyday(if there are any changes
in the details).
I made 2 combos...the COntract ID combo,and based on
thatthe user can select the products involved in the
contract ID..and all the details for the products are
displayed.
Now, I am trying to synchronize this setup with the date
combo. But it isnt working..the date combo gets values via
a now() function.any ideas, how to make the 3 combo boxes
work correctly?!?
thanks a million for your feedbacks and suggesitons!
With regards,
Samantha
I have a complicated problem.
I have a form that displays various details about a
product during different dates. I have a combo box where
the user can select a particular date he wants to see the
details for. The he has to select a contract from the list
of contract IDs available for that date. Then has to
select a product in the contract and he sees the details
for the product in the partcular contract in a particular
date.
I have a table that contains all the details i need to
display in the form. I have an append query, which adds
new records to the table everyday(if there are any changes
in the details).
I made 2 combos...the COntract ID combo,and based on
thatthe user can select the products involved in the
contract ID..and all the details for the products are
displayed.
Now, I am trying to synchronize this setup with the date
combo. But it isnt working..the date combo gets values via
a now() function.any ideas, how to make the 3 combo boxes
work correctly?!?
thanks a million for your feedbacks and suggesitons!
With regards,
Samantha