By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,842 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

Checkbox and Textbox in a Continuous Form

P: 2
Hi There

I am new to VB scripting in MS Access. I currently have a form with a subform embedded in it. I run a query based on search criteria which works fine.

Within the Subform there is a checkbox (Paid) that is displayed for each record. I want to enable the AmountPaid textbox for that INDIVIDUAL record, when the checkbox is True.

At the moment when I enable the checkbox for one record, ALL the Amount Paid textboxes for each record, becomes enabled.

Could someone please help me out, as I have trying to solve this problem for over 4 days now.

Kind Regards

Thuveshen
Mar 21 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi There

I am new to VB scripting in MS Access. I currently have a form with a subform embedded in it. I run a query based on search criteria which works fine.

Within the Subform there is a checkbox (Paid) that is displayed for each record. I want to enable the AmountPaid textbox for that INDIVIDUAL record, when the checkbox is True.

At the moment when I enable the checkbox for one record, ALL the Amount Paid textboxes for each record, becomes enabled.

Could someone please help me out, as I have trying to solve this problem for over 4 days now.

Kind Regards

Thuveshen
You need to use conditional formatting (On the Format menu) on the Amount Paid textbox. Set the textbox Enabled property to No. In conditional formatting set an expression [paid]=-1 and unclick the enabled icon on the wizard. This should work.

Mary
Mar 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.