B
Bateman28
Hi
I am having a little bit of trouble with an update scenario. I have a
database form that collects specific data depending on the work being carried
out by different agents. The form has some VB code so that when an agent
clicks onto a specific field, the corresponding fields that need to be
completed change colour. Also within my form, for the agents to continue to
a new form they need to select specific fields to enable the finish button.
These options work fine on the inital open of the database form, the problem
is that the fields will not reset back to their orginal state once an agent
has clicked finish.
By that i mean the fields that where complete are sent to the backend of the
database but the field colours will not refresh, its the same problem with
the finish button, once the button becomes visible from clicking on the
correct fields that are require, the finish button stays visible unless the
agents close the form and go back into the form, as you can imagine thats not
pratical
Any help would be greatly appreciated
Code Example:
Private Sub chkCheckedBUG_BeforeUpdate(Cancel As Integer)
If Me!chkCheckedBUG >= 0 Then
Me.cmdFinish.Visible = False
Else
Me.cmdFinish.Visible = True
End If
Me.Refresh!
End Sub
I am having a little bit of trouble with an update scenario. I have a
database form that collects specific data depending on the work being carried
out by different agents. The form has some VB code so that when an agent
clicks onto a specific field, the corresponding fields that need to be
completed change colour. Also within my form, for the agents to continue to
a new form they need to select specific fields to enable the finish button.
These options work fine on the inital open of the database form, the problem
is that the fields will not reset back to their orginal state once an agent
has clicked finish.
By that i mean the fields that where complete are sent to the backend of the
database but the field colours will not refresh, its the same problem with
the finish button, once the button becomes visible from clicking on the
correct fields that are require, the finish button stays visible unless the
agents close the form and go back into the form, as you can imagine thats not
pratical
Any help would be greatly appreciated
Code Example:
Private Sub chkCheckedBUG_BeforeUpdate(Cancel As Integer)
If Me!chkCheckedBUG >= 0 Then
Me.cmdFinish.Visible = False
Else
Me.cmdFinish.Visible = True
End If
Me.Refresh!
End Sub