I have frmStandard that displays a regimen of drugs for a disease. The drugs,units, and cycles populate into a listbox on frmStandard from a query against tblRegimens.
On frmStandard, I have a button that opens a second form, frmAlternate, that also has a listbox that is populated by a macro that runs a make-table query against the listbox in frmStandard and pulls the data from a "temp" table.
The reason for this is to allow the user to add/delete/modify the data in the frmAlternate listbox without altering the standard regimen data.
My problem comes when multiple users are using the forms and try to build an alternate regimen at the same time. The macro fails for one user because another user may be in the frmAlternate which has a lock on the "temp" table.
How can I get the above functionality from my application without causing conflict when multiple users are on the same forms? I was possibly thinking I need to build some type of array vs. a temp table, to populate the frmAlternate listbox but not sure how to go about this. Any suggestions or help would be great.
On frmStandard, I have a button that opens a second form, frmAlternate, that also has a listbox that is populated by a macro that runs a make-table query against the listbox in frmStandard and pulls the data from a "temp" table.
The reason for this is to allow the user to add/delete/modify the data in the frmAlternate listbox without altering the standard regimen data.
My problem comes when multiple users are using the forms and try to build an alternate regimen at the same time. The macro fails for one user because another user may be in the frmAlternate which has a lock on the "temp" table.
How can I get the above functionality from my application without causing conflict when multiple users are on the same forms? I was possibly thinking I need to build some type of array vs. a temp table, to populate the frmAlternate listbox but not sure how to go about this. Any suggestions or help would be great.