Filters *SOS* Filters *SOS* Filters *SOS*

V

valdaiway

1) On formLoad, I need to show only those items which are unassigned.

2) I need for the end-under to select only the items they are assigned to.

3) I need an option to select "ALL" so I can view all items.

Any insight offered would be appreciated!!!
 
J

John W. Vinson

1) On formLoad, I need to show only those items which are unassigned.

Use a query to put a criterion on the field that defines the assigned status.
I assume you know how that information is stored in your table; nobody here
does, so we can't tell you just how to do that.
2) I need for the end-under to select only the items they are assigned to.

"end-under"??? And again... we can't see your table, and have no idea how this
would be done. Is this the same form? It sounds like you want to see only
unassigned items, and at the same time only items assigned to the
"end-under"... ah... end user??? which is a contradiction.
3) I need an option to select "ALL" so I can view all items.

More info needed.
Any insight offered would be appreciated!!!

Please post enough information about your table structure that someone who
cannot see your monitor might have a chance to answer.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top