[AccessD] Easy question

jwcolby jwcolby at colbyconsulting.com
Mon Nov 5 12:57:53 CST 2007


I would guess that this is happening because you are testing for a true /
false in the checkbox and when you hit the new record the checkbox is null.
Is the actual checkbox control default value false?

As to your question OnCurrent is the event that fires when the form moves
from record to record. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James Miller
Sent: Monday, November 05, 2007 1:07 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Easy question

Okay. I know this is probably something really easy I'm overlooking, but
right now I'm drawing a blank and hope someone can point me in the right
direction.

 

I have a form with two checkboxes on it..  form is tied to a table. and when
the checkboxes are "true" I have a text box that appears for some text to be
typed in. when the checkbox is unchecked, the text box is set so the
visibility is false..  This works fine on my form, until you move to the
next record. and then no matter what state the checkbox is, the textbox will
be visible or not depending on how it was left on the last record.  (I hope
that made sense).

 

My question is, what event do I need to add my code to, so that it will set
the textbox properties correctly after the new record appears on the form.
I have tried all the events I can think of, and none work..   I'm assuming
there should be a way to  capture the record change event, but I can't seem
to find where to do that.

 

Any pointers would be greatly appreciated!!  I know this is probably so
easy...  LOL

 

James

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list