Creating User friendly Search Forms

[BernardKane]

I am using Acess 2010 (beta). I have a form with a sub form. The idea is that the user should enter a search criteria in a text box in the main form and all related records are then shown in a datasheet in the subform. I don't want to use the MS standard search wizzard as I want to limit the number of search fields and also make it easy for the user. Can anyone point me to a video tutorial for this or guide me on how to do this. I have looked at other similar questions asked before but none really answer my question.

[llkhoutx]

Modify the subform recordsource query criteria or set the subform Filter & FilterON properties appropriately.

[BernardKane]

Thanks for the advice I will try it but I have coded now in VBA.

[sesproul]

What us the action of the Filter, and Filteron Properties?

Steve

[llkhoutx]

The form Filter property is used as criteria for the forms recordsource, e.g. "ID=1"

The form FiiterOn property, if True, applies the Filter to the form recordsource, and if False, prevents the Filter from being applied.

In constructing a filter property,
(1) text data is enclosed with tic marks, e.g.
me.filter="FieldClientName='" & me.FieldClientName & "'" or
me.filter="FieldClientName='" & "Jones" & "'" or
me.filter="FieldClientNam<>'" & "Jones" & "'"
(2) date data is enclosed with #, e.g.
me.filter="FieldDate=#" & cdate(me.FieldDateFilter) & "#" or
me.filter="FieldDate=>" & cdate(me.FieldDateFilter) & "#" or
me.filter="FieldDate=<" & cdate(me.FieldDateFilter) & "#" or
me.filter="FieldDate=<>" & cdate(me.FieldDateFilter) & "#"
[Use the cdate function on date fields.]
(3) Numeric data is not enclosed, e.g.
me.filter="FieldCount=" & 3 or
me.filter="FieldCount>" & 3 or
me.filter="FieldCount<" & 3 or
me.filter="FieldCount<>" & 3

each is then followed with FilterOn = True or False, as the case may be.

[sesproul]

So this is basically adding a temporary "WHERE ..." statement to the end of the recordsource query?


Steve

[llkhoutx]

Yes it is, but without the "WHERE "

[sesproul]

thanks - this ACCESS interface is beginning to make sense.