Visible True/False

[pd06498]

In the database I am working on, I have a form that records the serial numbers of pages or forms in a book. For instance, a book might have pages 001201 to 001300. These numbers are unique and no two similar types of books or forms will have the same series of numbers. I also have a start and end date for each book or series, which I use to indicate if the book is in use, has never been used, or is used and finished.

Every so often, there is an inspection of these books to ensure accountability. At this time, I need to be able to identify those books currently 'in use' and input another entry indicating what serial number the book is up to at the time of the inspection. This serial number may change from inspection to inspection, and I just need the information from the latest inspection. Once a book is completed (indicated by the 'end date' field being completed), this information is no longer needed, just the start and end serial numbers and start and end dates.

What I am after is any ideas on the best way to tackle this, i.e. hide/unhide the additional serial number under particular conditions. I have tried a couple of methods using code but get errors advising that particular records cannot be saved.

Also, with the above scenario, is it necessary to save this additional serial number in my table or can it just remain in limbo until changed or is no longer needed.

Any pointers would be appreciated.

 

[Jerry Stoner]

Use queries to show the information you want to show in each scenario then add an option group and change the record source of the form to the appropriate query based on the operators selection in the option group.