make selecting from combo box be easier

[Guest]

I have a combo box set up that lists a rate,state,county. I need to select
the rate based on the county. I have bound the rate because that is the
value that needs to be stored. However, to find the correct state and county
I need to do toooo much scrolling. Help.
Can Iset up a combo box to jumbo to the county as I type it even though the
value I want to store is the rate.-

WOULD PREFER NOT TO SCROLL

Thanks,
Barb

 

[fredg]

I have a combo box set up that lists a rate,state,county. I need to select
the rate based on the county. I have bound the rate because that is the
value that needs to be stored. However, to find the correct state and county
I need to do toooo much scrolling. Help.
Can Iset up a combo box to jumbo to the county as I type it even though the
value I want to store is the rate.-

WOULD PREFER NOT TO SCROLL

Thanks,
Barb

Do it a bit differently.

To store the rate in the table, use a text control bound to the Rate
field in your table. You can lock it if you don't want the user to be
able to change the rate.

Add an Unbound combo box to the Form.
As Rowsource, something like this:
Select County, State, Rate from YourTable Order By County;

Leave this combo's Control Source empty.

Set the Column Count property to 3
Set the Combo Widths property to
1";0.5",0.5" (or whatever size works for you).

Set the Combo AutoExpand property to Yes.
Set the LimitToList property to Yes.

Code the Combo Box AfterUpdate event:
[RateControl] = Me!ComboName.Column(2)

The Combo will display the Counties in the first column, the
associated State in the 2nd column and the rate in the 3rd.
Find the correct county/state, select it, and the rate will appear in
the text control.

 

[Guest]

Need More Help

I did what you said. I am getting the drop down list for the "unbound combo
box- not sure if it is unbound. I am not able the see the county and state
data - but can see the rate when I drop down and the rate I pick goes into
the orignial date field. I obviously have something wrong on the combo box
setting. Should the bound column be what1 or 3??? Is there anything I need
to do different to see the data in Column 1 and 2.
I put the column widths and column counts that you said. HELP

Thanks,
Barb

 

[fredg]

Need More Help

I did what you said. I am getting the drop down list for the "unbound combo
box- not sure if it is unbound. I am not able the see the county and state
data - but can see the rate when I drop down and the rate I pick goes into
the orignial date field. I obviously have something wrong on the combo box
setting. Should the bound column be what1 or 3??? Is there anything I need
to do different to see the data in Column 1 and 2.
I put the column widths and column counts that you said. HELP

Thanks,
Barb

The combo box is used only to select the proper county (and rate) and
populate the other control [Rate] with the correct rate. If the Column
count is not set to 3, and/or the column widths are not wide enough,
you will not see all the columns.

The Combo Box RowSource should include only the County, State, and
Rate Fields (IN THAT ORDER).
The bound column can be 1.
The Combo Box's Control Source should be blank.
The Column Count property set to 3.
Let's try making the column widths a bit wider.
The Column width property set to 1";1";1"

It is the Combo box AfterUpdate event that populates the [Rate]
control with the Rate data.
[Rate] = [ComboName].Column(2)
(Note: Combo Boxes are Zero based, so Column(2) is actually the 3rd
column.)

The [Rate] control's control source should be set to the [Rate] field
in the table.
Make sure you use the actual control and field names and not my
generic ones.