Form based on query and table

[Toan Chau]

Good morning all!

I'm sure this is an easy question for you experts.

I have these columns in my table...

OS Equip Type Notes
TEXT TEXT TEXT MEMO

All are columns are text except Notes which is in memo.

I make a form based on a table and do these steps...

1) I create a list box and choose the option "Find a
record on my form based on the vaule I selected in my list
box." for that list box.

2) I have a field on the form with Notes in it.

The list box shows all records in the table. When I click
on a record the messages for the Notes field for that
record appears in the Notes field on the form. And that's
what what I need.

But...I can't filter the list box because it's based on a
table and not a query.

But if I create a query and make a form based on that same
query (instead of the table). And then I repeat steps 1
and 2...the message in Notes does not appear when I click
on an record in the listbox. Why is that?

Want I want is the ability to click on a record, in the
list box, and get the resulting message for that Notes in
the Notes field--like with the form based on a table.

But I would also like to be able to filter my list--like
with a query.

Is there a way to get both?

Thanks for any help you can supply me.

--Toan