Prev: Events for a multiselect list box
Next: How to use Or in txtbox
From: sebastico on 26 Apr 2010 16:20
Hi
Working in a relational db in Access 2003 I have a continuous form (MyForm).
In Header section of the form I have an unbound txtbox control to enter
words separated by Or. After entering the word(s) user click a button to
trigger searching the word(s). My form is based on Allen's Browne search
example. Thus searching controls are in Header and founded records must be
displayed in form2 rather than in Details of the Myform.

From: John W. Vinson on 26 Apr 2010 18:21
On Mon, 26 Apr 2010 13:20:02 -0700, sebastico
<sebastico(a)discussions.microsoft.com> wrote:

>Hi
>Working in a relational db in Access 2003 I have a continuous form (MyForm).
>In Header section of the form I have an unbound txtbox control to enter
>words separated by Or. After entering the word(s) user click a button to
>trigger searching the word(s). My form is based on Allen's Browne search
>example. Thus searching controls are in Header and founded records must be
>displayed in form2 rather than in Details of the Myform.

You can't pass an operator such as OR as a parameter to a query - only actual
data. If you want to pass multiple criteria you will need to actually build
the SQL string in code (and giving users the chance to enter any arbitrary SQL
string is probably unwise: http://xkcd.com/327/)

--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Events for a multiselect list box
Next: How to use Or in txtbox