How to Find Gaps in Your Check Number Sequence in Microsoft Access

[@Shadow.Dragon]

Very interesting video, Richard! Looking forward to the next in the series!

[@alializadeh8195]

Thanks

[@phillavonas3285]

Have a question regarding searching for data. I have a stock room and I want to have a form for checking out inventory. I'm trying to allow people to search for inventory, first by using a list box to narrow the search into a part number, description, category, location and then I was going to also use a text box. I was thinking someone selects let's say category and types glasses then the results would be displayed if they mett both criteria in an output box. Or maybe they know the location the item is in and the type in the location and the result would display all parts that are in that location. How would I do this? Thank you