Combine 3 Forms into 1 Tabbed Form

[AKATemp]

Hello all,

I will try to give a little background. I made a form for our office to search data through our MS Access database. It was a big hit, and people started using it. Then came another request to make a new form - to search through another few tables. This was a big hit too.

The same process repeated and now I am stuck with 3 different forms, each with it's separate code and selection options.

How can I combine all of them into one and have 3 different tabs for the 3 existing forms without losing all the coding and software flow that I have already created?

I have a bad feeling that it's not easy and will require considerable amount of recoding for me.

 

[vbaInet]

Good to know you've had 3 hits, all going platinum

But the explanation you've given is pretty vague. You've not included any code, any information about the record source of the forms, no screenshot of the forms in question, no code... etc. You get the drift.

 

[AKATemp]

Hi vbaInet,

Sorry, I did not post any code. There is a ton of code behind the three forms. But the basic gist is that each form has combo-boxes, list boxes and using IsNull condition statement, I dynamically make a query from tables that are also in the database and create a new table to display the result.

Please ask me if you need any specific code, so I can paste it here.

Here is a screenshot of forms. I hope this helps. I have trimmed some parts of the form, because I am not comfortable pasting all the information here. But the idea is the same.

The idea is the combine all these 3 forms into a master form called

"Master Form" with 3 tabs - Process/Material/Component

All screenshots are in Layout view.

 

[vbaInet]

We still need to know if all three forms use the same Record Source.

 

[AKATemp]

Hi vbaInet,

What do you mean by the same record source? The same tables? Yes, some of them do.

Attached is a pic of the database and the forms. The forms build query from the tables listed on the left.

Regards,

 

[vbaInet]

Yes, Record Source as in the tables/query the form is bound to. Record Source is a property of the form.

If you wan to put them as separate tabs then you do so using a subform control. Nothing will change on the code.

 

[spikepl]

And the benefit of talking something which is working, and putting effort into changing it so it looks a bit different but functionally remains the same, is what exactly?