Solved VBA form issues from a newcomer

[GPGeorge]

Pat beat me to it. "Most wanted" or "Top 10 Wanted" should just be another status that would change according whether you ordered it yet. Then you don't need the checkbox at all.

Back to basic table design before worrying about form design, as I said before.

 

[Pat Hartman]

It comes down to normalization. When you have two pieces of data that are mutually exclusive, you ought not to have two separate pieces of data. You have 1 column with one value or another. THAT is how you handle mutually exclusive

 

[MediaHolic]

Good morning Pat and George,

Yes thank you both for the comments. As I stated, I'm still learning and insights like this are invaluable. The advice is very much appreciated. Thank you.