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
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