Combo box values not selectable.

[klufkee]

Hello all,

I had previously posted a problem with combo boxes but now I'm trying
it a different way.
I have one table with 22057 records on it. I created one form to look
through those records. there are 57 different fields in the table. What
I would like to do is have the form display one record at a time.
(Which it is doing now.) I would also like to be able to use the combo
boxes on the form to filter the results that are displayed. For
example, if there are 200 records that have the same 'Business_Name'
then by selecting that name from the 'Business_Name' combo box would
filter the results to just those 200 records. From there I would like
to filter even further by selecting a value from another combo box. For
example, in those 200 records only 10 match a specific date and
selecting that date will narrow the results to show only those 10
records. Not entirely sure if this is even possible, (I'm very new to
Access), but I hope so. The issue I'm having now after creating the
form is that you can see all the records by scrolling through them with
the mouse wheel or using the navigation buttons at the bottom, but when
trying to select a value from a combo box the 'error beep' is heard.
Not getting an error message in the status bar at the bottom though.
Any ideas or help would be grand.

Thanks,
Bill

 

[klufkee]

Sorry, I left somthing important out. The data that is in the table
does NOT need to be updated. No new records will be added and none of
the info will ever be changed. I was able to make the values in the
combo boxes selectable by setting the Recordset type to 'Dynaset
(Inconsistant Updates)' but this looks like it is changing the info in
the fields when selecting from a combo box instead of just jumping to
the records that contain that value. And I'm scared that by doing that
it will change the data in the table. That is something I definately do
not want to do.

 

[BruceM]

This is a method that filters the combo box choices, which may accomplish
what you need:
http://www.mvps.org/access/forms/frm0028.htm

200 records with the same company name suggests there are some normalization
issues with your database.