Hello,
I am fairly new to MS Access. I have created a database for a company and they need around 250 pages of reports generated per client. I have all the reports, forms, and tables working correctly.

I have the database split with the back end on a network drive and the front end on each work station. The database has worked great for their first client.

Now, the issue is; they want to add a second client; and they can do that with the Add new client button I created. But, when they go to their reports it will display both clients data.

For example:

Client A has Building A , B , and C. Client B has building D , E , and F. When they go to print the report "Buildings Report"; they will get all six buildings in the report; when only ONE clients specific buildings are desired.

I know there is a solution to this; I would just like some insight and suggestions on how to go about it. I have a unique field "Client_ID" that sorts the reports based on the client. Now how would I get it to prompt to the end user to select which Client's data they want to use for the report; before its generated?

Thanks!

Nevermind, question answered. Pretty much every other thread in this forum is about this topic haha! Sorry!

Never mind Every other post is about this topic.