Need to allow users to login/update data after files are filtered. 1

[Sherman6789]

We have a database consisting of a table listing sales items, qty, salesman and sales year. The salesmen have been assigned to monitor selected items. The items are separated into groups. We would like the salesmen to sign on using a sign-on form with password. After a successfully sign-on, the user will see another form where the user will select the "year" of interest and select the type of update to be used. the final form will present a listing of all items assigned to the user who is signed on and only items that are in the Year selected.

1. Password Table consists of: User name, password, and item group

2. Password Form: same as above with pulldows for user name and OK/Cancel buttons
Item table consists of: Item names, Qty, user name and year

3. Eight query tables are copied from the above table and numbered 1-8. They are filtered by user groups 1-8. Example: Query table 3 will only show group three items.

We would like for the "user group" selected from the password form to be used to select the proper query table. We would also like the
program to automatically limit or filter by date and user group.

Finally, the user will be able to update, view and print from the limited items available from the proper query table.

Also, rather than have eight query tables, how can the filter of user group and year be done "on the fly?"

Please help.

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Sherman6789]

Thanks for answering PHV,

I have created and populated all of the forms and tables. I now know how to allow the user to select his or her name from a pull down and enter a password. The system compares the name and correct password to the input. If the password is incorrect, the program stops. If the password is correct, the next screen pops up.

I need to know how to use a search button to get the user's name and the selected year to filter the items on next form. The user will be able to modify only his or her files for the year selected.

I don't know how to write that short code and where to put it. I was thinking about making a query for each user as a way to filter the items. I know that is not the best way.

Any assistance will be appreciated.

 

[Sherman6789]

I forgot to mention that in addition to the table of data created; I have created a duplicate query table. I think that making a filter migt be easier with a query table than a regular table. Is this true?