 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Form Control searches records in Table for a value
I have a trouble call ticket form and before the user can send it to close with a combo box selection I want the Trouble Ticket number searched in the Assigned Techs Table to make sure all Completed are marked "Yes" if not then it will exit the sub and inform (msgbox) the user that they cannot close until "assigned user name" (could be more than one) is completed. I've listed the two tables I have and the fields that are needed for this action just do not know where to begin on coding it. I'm assuming on the BeforeUpdate of my combobox that sends the ticket to close but how do I have it search the table for Completed value and return the message if it isn't complete? I have two Tables: T_TroubleCalls (TroubleID) T_AssignedUsers (AssignID, TroubleID, AssignedUserName,Completed) By setting the field's in the table as required access will automatically do this for you. > I have a trouble call ticket form and before the user can send it to close > with a combo box selection I want the Trouble Ticket number searched in the [quoted text clipped - 11 lines] > T_TroubleCalls (TroubleID) > T_AssignedUsers (AssignID, TroubleID, AssignedUserName,Completed) >By setting the field's in the table as required access will automatically do >this for you. [quoted text clipped - 3 lines] >> T_TroubleCalls (TroubleID) >> T_AssignedUsers (AssignID, TroubleID, AssignedUserName,Completed) I understand the required setting in the table, however, in T_Assigned Users the Completed column is N/A, No, Yes, Returned, I need it to check to make sure all Assigned Users on the ticket are a Yes upon the action of changing the combo box from "Pending" to "Completed" if I set the table field to required it will already see there is a value there wouldn't it? I need it to look for a certain value (on the before update event (I think) of the combo box that the user selects the completed action from....... and loop through all assigned users that have the same Trouble ID number then return a yes (proceed with action) or a no (msgbox, User "abc" is not complete). |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.