So you have a list of job numbers, and when one is taken you want it to just not show as available anymore? How about a simple y/n field in the job table, IsAvailable? That way you just check the box that the job number is taken and a simple query will let you not show the taken ones. Does that work? I cover simple queries like this in Access Beginner 1. Unless I'm missing something and there's more to it.

Thanks.  I will give that a try.  I was thinking of a board that had job numbers and a small description.  Then when a plumber took it, the job button would be dimmed, letting others know it was taken,  something like that.  I apologize for not being more specific.  I am new to all this and I need to learn more before I ask a question.  Wanted to let you know your lessons and availability are informative and encouraging.  I'm all alone trying to put this together and just knowing a real person is reading this means a lot.  I can't afford a lifetime membership but I certainly can afford $30/mo.  A fantastic deal.  Thank you again Mr. Rost.  Cheers, Mark in Colorado.

You could certainly do something like this with a little conditional formatting. Use a checkbox to indicate when the job is taken and then you could have that whole row go gray. See this video for help: Checklists

That is perfect.!.  As an Excel user I make use of conditional formatting regularly.  That is a great solution.  Thank you for your help.  Sincerely, Mark in Colorado.

My pleasure!