Display a field depending on contents of other field

M

Mezzo Anna

I have an issues database and I'd like to have a field enabled depending on
the entry in another field. For example: if the category of issue is
"Delinquency" I'd like to enable entry in a field called "Due Date",
otherwise disable it. I could do it by creating two forms depending on the
type of entry, but I'd rather be more sophisticated.

Any ideas?

Thanks
 
L

Larry Linson

I have an issues database and I'd like to have
a field enabled depending on the entry in another
field. For example: if the category of issue is
"Delinquency" I'd like to enable entry in a field
called "Due Date", otherwise disable it. I could
do it by creating two forms depending on the
type of entry, but I'd rather be more sophisticated.
Click to expand...

It'd be simpler to give you code if you gave the name of the Controls in the
Form, and it would save our having to explain or you to guess (I'm going
with the latter option):

If Me.cboCategoryOfIssue = "Delinquency" Then
Me.txtDueDate.Enabled = True
Else
Me.txtDueDate.Enabled = False
End If

If you wanted to do this in the Table's Datasheet view, sorry, you can't.

Larry Linson
Microsoft Access MVP
 
Top