I need some help on two problem I'm working on. First, I have an
option group button with a checkbox called Inactive that allow me to
open up a new blank form and input new record, but the problem with it
is that once I input new record and save it, I can't go back to
previous record, In order to view all my record, I have to close and
reopen the form, this is the code I have so far:
If Me!optFiling = 2 Then
Me.DataEntry = True
Else
Me.DataEntry = False
Second, I have a combo box called Disposition Code Row Source from
tblDispositionC ode, I want if the user select one of the choice e.g "Do
Not Pursue" or the field is left blank for the Inactive checkbox to be
lock. This is what I have so far but not sure were to put it.
IIf([Disposition Code] = "Do Not Pursue" Or [Disposition Code] is Null,
Inactive.Lock = True).
Thanks in advance
option group button with a checkbox called Inactive that allow me to
open up a new blank form and input new record, but the problem with it
is that once I input new record and save it, I can't go back to
previous record, In order to view all my record, I have to close and
reopen the form, this is the code I have so far:
If Me!optFiling = 2 Then
Me.DataEntry = True
Else
Me.DataEntry = False
Second, I have a combo box called Disposition Code Row Source from
tblDispositionC ode, I want if the user select one of the choice e.g "Do
Not Pursue" or the field is left blank for the Inactive checkbox to be
lock. This is what I have so far but not sure were to put it.
IIf([Disposition Code] = "Do Not Pursue" Or [Disposition Code] is Null,
Inactive.Lock = True).
Thanks in advance
Comment