blue1914mab
Technical User
Since I am new to Access, I will take the long way around the block to ask this simple question.
At initial logon, a "Welcome/Status" page for each user (based on their UserID) is the first page they see (there is no traditional switchboard). This page is designed to show the records they have been assigned, as well as various stats based on that.
I have an unbound txt box on this page that I would like to show how many "Patient Records" they currently have assigned to them.
These patient records are stored in another table called tblPatientInventory. On "frmSetInformation" (bound to tblPatientInventory)there is a button that when selected, changes the status to "Checked-Out" from "Available", date stamps it, and based on EmployeeID, post their last name.
What would be the code for the unbound text box on the Welcome/Status page to show how many "Total" records have their EmployeeID associated with it. This would tell them how many Patient Record they currently have assinged to them.
At initial logon, a "Welcome/Status" page for each user (based on their UserID) is the first page they see (there is no traditional switchboard). This page is designed to show the records they have been assigned, as well as various stats based on that.
I have an unbound txt box on this page that I would like to show how many "Patient Records" they currently have assigned to them.
These patient records are stored in another table called tblPatientInventory. On "frmSetInformation" (bound to tblPatientInventory)there is a button that when selected, changes the status to "Checked-Out" from "Available", date stamps it, and based on EmployeeID, post their last name.
What would be the code for the unbound text box on the Welcome/Status page to show how many "Total" records have their EmployeeID associated with it. This would tell them how many Patient Record they currently have assinged to them.