98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access VBA Training and help » microsoft access courses - Change caption on toggle button depending on underlying record
microsoft access courses - Change caption on toggle button depending on underlying record
Resolved · Low Priority · Version Standard
Ricardo has attended:
Access VBA course
Access Advanced course
Change caption on toggle button depending on underlying record
Hi
I have a form ( Frm_InvoiceRecord ) with a toggle button (CheckCMD), which is sourced to a checkbox in a table ( InvoiceTable ).
How can I alter the toggle button such that when the checkbox in the table is ticked the toggle button is pressed down, and the caption reads "Checked", and if the checkbox is unticked the toggle button is not pressed and reads "Unchecked".
Also the button needs to be unlocked for new records, such that a user can click it and it changes from "Unchecked" to "Checked". I have done this with the OnClick event, however I am having some problems with the first part
Any help would be gratefully appreciated.
Thanks
Ricardo
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hide Access TablesOne method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys. |