Field Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003.
I have a form in which one of the fields ([size2]) should only be completed
when another field ([type]) says "multiple". I want to stop anyone from
entering data into this field unless the the [type] field says "multiple".
In the Table Design, I tried to put a formula in the Default Value that would
protect the [size2] field. I put IIf[Type]="single","N/A"," ") but did
not work. Does anyone have any idea as to how I can make sure that
information into the [size2] field is only entered when the other field says
"multiple"?

Aurora
 
First, disable the the [size2] control in the Current event of the form:
Me.size2.Enabled = False

Then in the After Update event of the Type control:

Me.size2.Enabled = Me.Type = "Multiple"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Warn Users that Entered Numbers Are Not Divisible 4
Cascading Comboxes 2
Text fields concatenation 3
How to subtract a number from a Mergefield? 0
Import files into access 1
getting part of data to populate new field 2
Data entry for a table from a form 1
Restrict Choice in Shared WB (drop down alternative)? 0

Back
Top