And no, these are not three separate forms. This is a single form with buttons that are created based on the data in the table. It's the same form; we just use a little VBA to set the captions and the values in the buttons. That form can then return a value to whatever form called it. Once we get that make and model in here, we can save that in the vehicle information on the Customer Form.

It's a fun alternative to combo boxes, list boxes, option groups, and all the standard Access controls.

Are you making the buttons taller?

I left room for 18 of them. Lol. You can make them as big as you like.

I thought of another idea for the big button form, and this goes along with what you were saying, Alex, about using this for the POS database...

And that's changing the buttons to toggle buttons so you can make multiple selections for different options. For example, if you want a hamburger, you can select what you want on it (ketchup, mustard, relish, onions, mayo). And of course, if you want mayo, you'd get nothing but my scorn.

This will definitely be a lot more advanced, though. Either it will go in an Extended Cut, or perhaps if I make a template or a seminar out of it, I'll put it in that.

How about menus that work the same way? One form, all table driven.
Yeah, it's the same idea, just updating log tables, active task tables and spawning jobs.

@Richard I take it you're not a Big Mac secret sauce fan? (It's just thousand island dressing)

Menus: this could absolutely work for menus. I've done something similar in the past.

Big Mac: love me a BM... which is usually followed by an explosive BM. LOL

@Richard My first "real" job (with taxes being withheld) was at McDonalds when I was 16. I was part of a trio that developed the Egg McMuffin. So, it was all a good learning experience. But I hate MCD as a corporation.

The latest version...

One of my first real jobs work working phone-based software tech support in downtown Buffalo, right next door to a McDonalds. After a year of that, I couldn't even stand the smell of a McDs. Driving by one would get me sick. Now I'm good, but I couldn't eat it for years after that.

@Richard Oh yes, that smell of McD grease! I would come home and my mom would walk me straight to the shower. Then she would take my clothes straight to the washing machine. Even wearing a paper cap at work, it would take three applications of shampoo to get back to having regular hair.

I just thought of something. The men wore those paper caps, but the women had to use hair nets. I can't imagine how they got all that grease out of their hair. But, women were mostly on the counter while the guys managed the grill and fryers. Cleaning those grills and fryers at night? What a nightmare. There were 55 gal. drums out back filled with that grease, right next to the trash. The smell of either would make you gag. More than one trainee hurled when smelling both.

Ew.