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