From: sebastico on 26 Apr 2010 19:36
In my Database there is a Table storing selected words. To simplify what I
need, lets say that I have seven tables:
OOBID (Primary Key wounded to Foreign Key in Table2 and Table4 and Table6 )
WRDSID (Primary Key wounded to Foreign Key in Table2)
The selected words are stored in Table2. Records are displayed from Table1.
This means that once user enters one or several words in txtbox if such words
match with stored words, such records with fields from Table1 will be
displayed in the txtboxes in form (like Allen's Browne Search example).
Besides, I have more tables bounded to Table2.
FFAT (Primary Key wounded to Foreign Key in Table2)
SISTID (Primary Key wounded to Foreign Key in Table2)
I don't Know if with this design I can do what I need. If so, please let me
know. Your help is greatly appreciated
Thank you very much.
"John W. Vinson" wrote:
> On Mon, 26 Apr 2010 13:20:02 -0700, sebastico
> <sebastico(a)discussions.microsoft.com> wrote:
> >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]