Hi,
So i have on a form a button that runs an update query to allocate a user 20 records from the main table of records that need to be processed. as the update runs it completes the user name in the field "Allocated to". I am looking for a way so that when they click the buton again it does not allocate a further 20 until they have completed the 20 they already have.
so was thinking of using .... but this doesn't work it just adds a further 20
If DCount("*", "Working") = 20 Then
DoCmd.Close acForm, "Working_Completed"
Else
DoCmd.SetWarnings False
DoCmd.OpenQuery "Allocate_Completed"
DoCmd.SetWarnings True
So i have on a form a button that runs an update query to allocate a user 20 records from the main table of records that need to be processed. as the update runs it completes the user name in the field "Allocated to". I am looking for a way so that when they click the buton again it does not allocate a further 20 until they have completed the 20 they already have.
so was thinking of using .... but this doesn't work it just adds a further 20
If DCount("*", "Working") = 20 Then
DoCmd.Close acForm, "Working_Completed"
Else
DoCmd.SetWarnings False
DoCmd.OpenQuery "Allocate_Completed"
DoCmd.SetWarnings True