Clear button not working. What's wrong?

[MustbeAweful]

Sorry, I forgot about the continuous form not being colourable. Does it matter where I put the code you've given me?

When I mean "searchable" I mean that, on the menu, that I can select "Type" as either Driver, Assistant, or Versatile, and have results that narrow it to that field. Much the same with the check-box Sat/Sun/Mon/Tues/etc.

Much appreciated for the help.

[davegri]

The code snippet goes in the DriverDetailF. The black code is existing and the red new.

Your driver type introduces some severe complications. If a user searches for type Driver and the person is Versatile, that is not a match.
And if search is for Versatile, neither Driver or Assistant is a match. To further complicate, can a Driver be an Assistant?

[MustbeAweful]

⍨ Hmm...

For the sake of answering your question: Rarely do Drivers want to be Assistants or vice versa, that's why I thought I'd make Versatile a category. Guess I didn't think things through.

Maybe it's best to keep it as coloured on the continuous form to draw the eye. Scratch the searchable part.

[MustbeAweful]

Okay! I've put in your code, which brings it up the DriverDetailF as a reddish colour, great! To be more obvious on the continuous forms, I've put a colour changing square behind IsActive? (the same way that the Sat/Sun/Mon/Tues/etc are colour changing when clicked upon).

Is there a way to put all inactive drivers at the bottom of the continuous form? Did I already ask you this question before?

EDIT: Yes I did. I didn't comprehend your response back about it... I guess that's it

Thank you again for all of your help! I'm going to get a lot of good use out of this

[davegri]

Is there a way to put all inactive drivers at the bottom of the continuous form? Did I already ask you this question before?

That's when I made the listbox that shows the NA drivers at the bottom. I've expanded that to show the inactive at the bottom of both forms.
This version also includes the code to color the DriverDetailF but not the MenuF box.

I left the controls for the driver type intact, but made them not visible.

Driver Database-davegri-v8a.zip