Intractable Combo Box problem!

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have a small pop-up form with a Combo box on it.

This Combo box is based on a totals query and its purpose is to put values
from 2 columns of the combo into two text boxes on the same form. (Later
these text boxes will be used as parameters for a Report based on another
query.

The names of the columns are "Customer" and "Date" this latter being in the
mmmyy format.

I use the Column Property which in this case means:
=[Combo6].[Column](4) for the date "mmmyy"
=[Combo6].[Column](1) for the customer.

In the combo box results a Customer can be listed many times against a
unique date.

No matter what I try the Column property returns the top date only for a
customer group!

Please help, Frank
 
probably because you don't have a unique key for each record in a Totals
query. hopefully you have a tblCustomers with a primary key field, providing
each customer with a unique identifier. if so, suggest you try two combo
boxes: base the first combo box on tblCustomers, with the bound column
being the primary key field. base the second combo box on the table that has
the "date" field in it, filtering by the primary key value from the Customer
combo box. that way the Date combo box will only display dates for the
chosen Customer.

note: recommend you don't use the word "Date" as the name of any field or
alias in your database. Date is a reserved word in Access, and will cause
problems if you appropriate it for your own naming uses.

hth
 
Back
Top