Jumat, 17 Mei 2013

[MS_AccessPros] Form - Parameter Query

 

Hello all,

Can someone please clarify my concerns;

If I created a form to get user fills the search criteria like below format,
I know that if I put these expression to my query criteria row I will get
the desired record. But what if, the user failed to filled out one of the
criteria? What happen, what is the result?.

This kind of approach, is it good/suitable for a multi-field criteria to use
on search form? If not what is the best for multi-field criteria search
approach, considering that maybe one or two field will contain a blank
criteria..

[forms]![frmEnterParameter]![txtFirstName]

[forms]![frmEnterParameter]![txtSurname]

Thank you in advance,

Zjubias

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar