Opening a record based on combo boxes

[Dan9684]

Hi everyone,

Wondering if someone might help me.

I have a large 'main' table with many fields, including Client, Umbrella, Fund, Month and Share Code. This has a form attached to it. No two records in this main table have the same combination of all five fields

I also have a menu. On this menu I have five drop down boxes, corresponding to the above five fields, and a button.

How would I get it so that when a user presses the button on the menu, the record in the form corresponding to the five selections in the drop down boxes appears?

i.e. if the user selects Client, Umbrella, Fund, Month and Share Code from the five drop downs on the menu, and presses the button, the main form appears at the corresponding record.



Thanks very much in advance.

[ranman256]

on a form that shows all records, filter the results of the combos:

build the 'where' clause by cycling thru all the controls....
it executes after a find button CLICK event
if null, ignore.
if not, apply.

'----------------
sub btnFilter_click()
'----------------
dim sWhere as string 
sWhere = "1=1"
if not IsNUll(cboST) then sWhere = sWhere & " and [State]='" & cboST & "'"
if not IsNUll(cboCity) then sWhere = sWhere & " and [city]='" & cboCity & "'"
if not IsNUll(cboZip) then sWhere = sWhere & " and [ZipCode]='" & cboZip & "'"
If sWhere = "1=1" Then
  Me.FilterOn = False
Else
  Me.Filter = sWhere
  Me.FilterOn = True
End If
end sub

[Dan9684]

Sorry you've absolutely lost me there. There is no form that shows all records, only a form that shows one record at a time?

State,City,ZipCode? Sorry I'm very confused.

[dashiellx]

Please review the attached.

It contains a demo of three ways that a form can be employed to create a dynamic query.

1) Using Combo Boxes to establish the criteria for the query

2) Using Multiple Multi-Select List Boxes to establish the criteria for the query

3) Using Text Boxes to establish date criteria for the query