Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access courses - change caption toggle button

Forum 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

ResolvedVersion 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

RE: Change caption on toggle button depending on underlying reco

Don't worry - I've worked it out myself.

It's simply a case of putting the code in the On Current event for the form in question (in my case Frm_InvoiceRecord).

Thanks anyway

Ricardo

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.