[Cialug] Access

David Stout cialug@cialug.org
Fri, 4 Mar 2005 12:47:17 -0800 (PST)


--0-615979285-1109969237=:7581
Content-Type: text/plain; charset=us-ascii

What is am looking for is to make the field required on the form it Status is "determined not reportable"

"Kevin C. Smith" <kevin@linuxsmith.com> wrote:
> I know this is not a forum for this type of post however I have exhausted
> all other forums and documentation to find my answer. So I have resorted
> to taking a chance at getting yelled at.
>
> Here goes:
>
> At work I am creating an Access2003 Database I have a form with a field
> called Determined Not Reportable By and a field called Status. The
> Determined Not reportable is only required if Status = "Not Reportable".
> How do I create validation to make the field Determined Not Reportable By
> when Status = "Not Reportable"?
>
> Thank you in advance
>
I'm not sure I understand the question.

"How do I create validation to make the field Determined Not Reportable By
when Status = "Not Reportable"?"

You can set the field to be not visible on the form, and then if "Status"
= "Not Reportable" use VB to set the field to visible.

On "Determined Not Reportable" set visible to "No" (under Format)
On "Status" field in Event "After Update" enter an Event Procedure:
Something like:

If Me.Status = "Not Reportable" Then
Me.Determined Not Reportable.Visible = True
Else
Me.Determined Not Reportable.Visible = False
End If

You can have it check the "Status" field on form load also if needed.
Not sure I helped, but this may be a start.

-- 
Kevin C. Smith
_______________________________________________
Cialug mailing list
Cialug@cialug.org
http://cialug.org/mailman/listinfo/cialug



David Stout
Business Forms Analyst & Student
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--0-615979285-1109969237=:7581
Content-Type: text/html; charset=us-ascii

<DIV>What is am looking for is to make the field required on the form it Status is "determined not reportable"<BR><BR><B><I>"Kevin C. Smith" &lt;kevin@linuxsmith.com&gt;</I></B> wrote:
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>&gt; I know this is not a forum for this type of post however I have exhausted<BR>&gt; all other forums and documentation to find my answer. So I have resorted<BR>&gt; to taking a chance at getting yelled at.<BR>&gt;<BR>&gt; Here goes:<BR>&gt;<BR>&gt; At work I am creating an Access2003 Database I have a form with a field<BR>&gt; called Determined Not Reportable By and a field called Status. The<BR>&gt; Determined Not reportable is only required if Status = "Not Reportable".<BR>&gt; How do I create validation to make the field Determined Not Reportable By<BR>&gt; when Status = "Not Reportable"?<BR>&gt;<BR>&gt; Thank you in advance<BR>&gt;<BR>I'm not sure I understand the question.<BR><BR>"How do I create validation to make the field Determined Not Reportable By<BR>when Status = "Not Reportable"?"<BR><BR>You can set the field to be not visible on the form, and then if "Status"<BR>=
 "Not Reportable" use VB to set the field to visible.<BR><BR>On "Determined Not Reportable" set visible to "No" (under Format)<BR>On "Status" field in Event "After Update" enter an Event Procedure:<BR>Something like:<BR><BR>If Me.Status = "Not Reportable" Then<BR>Me.Determined Not Reportable.Visible = True<BR>Else<BR>Me.Determined Not Reportable.Visible = False<BR>End If<BR><BR>You can have it check the "Status" field on form load also if needed.<BR>Not sure I helped, but this may be a start.<BR><BR>-- <BR>Kevin C. Smith<BR>_______________________________________________<BR>Cialug mailing list<BR>Cialug@cialug.org<BR>http://cialug.org/mailman/listinfo/cialug<BR></BLOCKQUOTE></DIV><BR><BR>David Stout<br>Business Forms Analyst &amp; Student<p>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com 
--0-615979285-1109969237=:7581--