The link below is my initial starting point of my post. I want to be able to edit the Recordset (in a Main / Subform / SubForm) DB, generated from codes in the referenced post below:
When a user changes any of the 4 most important fields, there must be an update that
does the folowing:
(a). UpDate the JobNo to reflect the changes made then,
(b). Regenerate ALL JobNos in the tblTaps to ensure JobNos
are in sequence.
(c). UpDates (a) and (b) should be performed simultaneously.
If possible, Lock the Database and then send message across the
Network that an "UPDATE is being performed, please wait...)
(d). When UPDATES are completed, the Message will disappear or another
message informs ALL users "Update Finished"
There are two parts here to the JobNos issue
(A). Creating New JobNo (currently being addressed in another post cited above)
(B). Just before a new JobNo is created, code could "Do"
(a) FindFirst if Like Operant Exist, if found "Do" Record Count and MsgBox to inform
User number of Like Operants found..Do you still want to add new JobNo?
(b). If the answer is Yes, Add new JobNo - Increment +1
(c). If the answer is "No", enable the cmdSearch button for User to search for "Like Operants"
matching the "current JobNo the Users is about to create".
A "ListBox" to display the "Like Operants" might be a good idea when cmdSearch is
clicked. Then, double-clicking on any of the displayed "JobNo" should open another form
(Pop-Up type) to reveal the details of each JobNo and the associated data from tblTaps
If the JobNo already exists (excluding the sequence number and date), either in New JobNos Mode or in the editing Mode, I want to prompt the user to see if he wants to create another JobNo described above.
Further Notes In the "Editing mode":
If after creating the JobNo, on the same day or some other day, User changes his mind and wish to make changes to any of the four fields, that's fine, but upon saving the data or when users tabs to the next field, there should be a message warning user, that fields changes would reflect in changes to the JobNo, Do you still want to Continue Yes/No. If he clicks Yes, then RUN Update query one after the other to update tblTaps and to any recordset the changes could affect including Regenerating all JobNos in the table making sure all numbers in the table increment accordingly and in a Unique manner.
Please note that the code for this particular post may not be possible untill solution for the above cited post has been achieved. This post is essentially part 2 of the first. Any help will be appreciated.