Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Checking for Limit Reached on a Form
I'm having a problem getting that to work. Is there a way to link a field from a query to a form that it's not related to? I have the fields patronid and datereceived on the form and the countofbooks field in a query. If I can relate them I think I can get it to work.<br> <br> Thanks,- Trisha
- Post #4
- Forum: Microsoft: Access Other topics
-
Checking for Limit Reached on a Form
I am working on a library project and one of the requirements is that a patron is limited to having no more than 5 books checked out at one time. I created a query that returns the number of books checked out based on a patron ID. I want to use the result of this query on the check-out form...- Trisha
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
