To add select statement in the Textfield's expression builder!

[Sam Hung]

Hi All,

I'm new in Microsoft Access 2000. For now I'm having
little troubles and would like to share with all of you.
I created a table "TableA" with 3
fields, "field1", "field2" and "field3".
I created a form and called the table "TableA" to list
the data in tabular form.
I'm attempting to add a text field - text1(data from the
table - TableA.field1) in the form in order to filter the
list of data in the tabular form. For example, as I
type "aaaaa" in the textfield, it should filter all
relevant data with "aaaaa" from TableA's field1 instead
of listing all. Now without using Queries, can I right
click "field1" to get into Expression Builder and use
select statement to filter the data, but it finally
failed.

My select statement is like this:
select * from TableA where TableA.field1=[forms]![text1]
this statement is wrong.

Should I have to use Query or some other methods? I want
to add new records anytime in the form. So, I guess Query
is not gonnabe a good way though.

Please help, thks
Sam.

 

[Kelvin Lu]

What you want to do is not as easy as you think. Access does not
continuously filter out data the way you want. A form performs the filter
before opening. You can get something similar to what you want but it will
involve coding using VBA. If you are new to Access, this might be over your
head and you should think of doing something different with your form.

Kelvin