Filtering using multiple fields

[poppet]

Hi,


How does one filter using multiple fields on a form?

If I have a pet database that has the following fields

petid
type
name

On a form I wish to select a pet type from a drop down box that shows a list of unique types of pets in the database (cat, dog, elephant).
If I select cat then in the next field I would like to select the cat's name from a drop down.
Then I would like to save the pet id for this selected pet in petid.

I guess it is a combination of combo box and save value for later use and then perform an updated query?
If it is this can you describe how you perform this updated query please?
Regards,
David.

[ranman256]

In the type combo AFTERUPDATE event
change the query to the Name combo box.
1 query is all the names, 1 query is filtered by the box: (select names from table where [type] = forms!frmMyForm!cboType)

sub cboType_Afterupdate()
   if isNull(cboType) then
         cboName.rowsource = "qsAllAnimals"
   else
         cboName.rowsource = "qs1Animal"
   end if
end sub

[June7]

Is this form bound to table?

Could make the names combobox RowSource like:

SELECT ID, names FROM Pets WHERE type = [cboType];

Then in cboNames GotFocus event:

Me.cboNames.Requery

Bind cboNames to the ID field.

Also might want code in cboType AfterUpdate event that sets cboNames to null

Me.cboNames = Null