Form layout is:
Form Header -- Has detail information, i.e., Name & RoomNumber

Detail Section -- 1 Row is defined.
Has 3 fields form a query: RoomNumber, Asset#,Desc.
plus a command button to mark it as inventoried.
The three fields are defined as text with the CONTROL
SOURCE pointing to the fields of the query.
Section is setup to GROW.



Form Footer -- Command button to exit.

When I display the form, everyting comes up great. I get all 3 detail records showing in the Detail Section.

What I am trying to do is apply a filter so that I only see the records for the room number displayed in the Form Header. I have applied a filter (and turned it on) during FORM LOAD, but it does not seem to work. Since it is giving me all the detail records instead of none, it appears that the filter is not being accepted at all. Or is it in the wrong place ?

Since I need to have a command button displayed on each line, I think I need to stay with the text box process. I have tested successfully using a LIST BOX, but no ability to use the much needed command button.

Any suggestions on how to properly apply the filter ???

Thank You.

Bob