simple to some

[Les]

I have a table called appraisers with [2 Units], [Condo] and
[3-4 Units] as Yes/No fields. I want to create a search form with a combobox containing the field names above where when users select from the combobox, the subform will be filtered with only the selected type marked as "True". I'm not very strong on vb and I need to know how to go about creating this search form.

 

[Les]

Finally got this working by creating a search form using a yes/no buttons based on a previous post :
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36145&highlight=searchhttp://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36145&highlight=search

For some reason, IsNothing does not seem to work on Access 2000. It worked when i used the converted database from 97 though.

 

[jjturner]

I don't use Access 2K, but just a simple check here - did you copy the IsNothing function from the 'Utilities' Module in the sample Access 97 DB into your Access 2K DB? (IsNothing isn't a built-in function in Access 97, so probably not built into A2K either.)

 

[Les]

As a work around, since IsNothing works on the converted database from 97 (so the wizard says), I copied and pasted all of my forms, databases, queries and reports into the converted one. Re: IsNothing being a built-in function in 97 or 2k is uhm... hmmm. I'll have to go with the saying "if it works, don't try to fix it" for now. =)