Query Screen

[AKoval]

Hello. I am new the both these forums and Access, and I have a question about a project I am working on.

I currently have a database full of client IDs, product names, and their costs. This database may be going out to a bunch of clients, and so I want to make querying data from this database as easy as possible. I can't send the database to the client have them create their own queries or filters, as all of the clients may not be Access-savvy to do that.



So this is I envision this database. When a client opens the database, a screen will pop up with a drop down menu. That drop down menu will contain a list of all of the client IDs. The client will select his corresponding ID, and then either the database or an Excel will pop up with all of the data that matches that correspond ID.

How can I go about creating that kind of database query/screen (Edit: not spreadsheet)*.

Further, is there a way I can built the drop down menu so a client can select multiple IDs? Some clients may have multiple IDs assigned to them, so I am wondering if I can create the drop down menu so a client can select all 2 or 3 of his IDs at once, or would he have to pull each ID separately?

Thanks in advance for any assistance!! I've been trying to find the answers online, but have not found something that would work.

* Edit. Essentially, the database is all built. I am just looking to see how I can create a query that would be its own separate screen. The client will see this screen when the open the database, and then select their ID(s) from a drop down menu and then either in Access or Excel, the data for that ID would populate.

[June7]

What do you mean by "How can I go about creating that kind of spreadsheet?" Access has tables, not spreadsheets. You have a database with data in it so you must know how to build tables.

Selecting multiple client IDs would require a multi-select listbox and VBA code to build filter criteria http://allenbrowne.com/ser-50.html

[AKoval]

What do you mean by "How can I go about creating that kind of spreadsheet?" Access has tables, not spreadsheets. You have a database with data in it so you must know how to build tables.

Sorry, I meant creating that kind of "database", not "spreadsheet". (You can tell how much more often I use Excel than Access).

But actually, I have the actual database built. What I really need help with is creating a separate screen that would pop up when I open the database. That screen would just have that drop down field where the client selects the ID, and then all they get is a database/Excel with the data that corresponds to that ID. So essentially, the client will never see the whole Access database, just the "output" from the ID they would select on this screen.

[June7]

Set that form as the default form when database opens. That is a database property setting.

Login form is a common topic in forum. Search forum or google. Start with https://www.accessforums.net/access/...ure-31683.html