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