Button click to open a list of forms (1 Viewer)

cawoody1 · Oct 26, 2019

Hi,
I am trying to create a cash/purchase ledger type system in Access. I have created a main menu form and on that is a button for the cash ledger. I have a table and form for each month of the year. What I want to happen is when I click the cash ledger button it asks me to choose a specific month, then after choosing the month it takes me to that form... Can this be done?? Help!!

arnelgp · Oct 26, 2019

there is no need to create separate form for each month.
just use one form for all months and just filter the form for the month to display.

theDBguy · Oct 26, 2019

Hi. Welcome to AWF! I agree with Arnel. It would be less maintenance for you if you use only one form.

Micron · Oct 26, 2019

What about having a table for each month? Is that not a bad idea?

cawoody1 · Oct 26, 2019

Thanks, I think for ease of use I will just use the one form and use the filter!

theDBguy · Oct 26, 2019

cawoody1 said:
Thanks, I think for ease of use I will just use the one form and use the filter!

I think that's a good idea. Good luck with your project.

Gasman · Oct 26, 2019

cawoody1 said:
Thanks, I think for ease of use I will just use the one form and use the filter!

That would be the way to go.
Imagine the work, if you added a new feature to a form.? Then do that times eleven again.?

You *might* be thinking in Excel mode with a worksheet for each month?

Button click to open a list of forms (1 Viewer)

cawoody1

New member

arnelgp

..forever waiting... waiting for jellybean!

theDBguy

I’m here to help

Micron

AWF VIP

cawoody1

New member

theDBguy

I’m here to help

Gasman

Enthusiastic Amateur

Similar threads

Users who are viewing this thread