synchronizing 3 combo boxes!!!

[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

 

[Guest]

So, you have one combo box for ContactID....one for Products and one for a
date. How do all of these relate to one another? What fields do you have in
your table(s) that have a direct bearing on your combo boxes? Please list
your tables, fields and relationships.

 

[Guest]

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

If you are using Now() to auto-enter a date into a field, be aware that you
are storing the date AND time. Searching for a date only or using a combo box
to select a date (from the date field in the table) will probably return zero
records.

Just using a date is equivalent (so I'm told) to mm/dd/yyyy 00:00:00. For
example, if you entered a record yesterday at 2:37pm, the field would (could)
have
4/10/2005 14:37:16. Searching for 4/10/2005 would return zero records.

And if you picked a date from the combo box (which includes the time), only
one record would be returned - the record that you picked in the combo box -
which is the only one that matches down to the second.

You could try changing the combo box row source to look something like this:

Select ......Where Int([ContractDate]) = int(Me.cboDate)


where Me.cboDate is the combo box on the form and [ContractDate] is a field
in the table.


If you wanted to remove the time component, you could run an Update query.