Use Findfirst to Match on Multiple Values 1

[spinalwiz]

Im using a combobox to navigate to records on a form, but I want to find a record based upon the value in the combox AND another value (which at the moment is another combobox, but will eventually be inherited from a parent form).

Can I use the findfirst command to match on two fields?

Thanks

 

[spinalwiz]

Err, I guess my question should actulally be 'how do I solve this problem?' it doesnt matter if i use findfirst or not.

 

[RoyVidar]

Hi!

[tt]rs.findfirst "fld1 = 'blah' and fld2<100"[/tt]

As stated in the help files, "It is like the WHERE Clause in an SQL statement, but without the word WHERE"

Roy-Vidar

 

[spinalwiz]

Great