Still need help finding a record where 4 criteria must match

[imwalrus38]

--------------------------------------------------------------------------------

How do I set up a search on my form where 4 fields must match exactly to return the correct record? I must match - persons name (text), description (text), type (text) and date (date). I would always search on all four fields.

Thanks
J

 

[Pat Hartman]

Use 4 separate unbound textboxes, combos, or listboxes. Reference these in your query.

Where fldA = Forms!YourForm!fldA AND fldB = Forms!YourForm!fldB AND fldC = Forms!YourForm!fldC AND fldD = Forms!YourForm!fldD;

 

[imwalrus38]

great... Thanks for your help

John