microsoft access courses - Change caption on toggle button depending on underlying record

The UK's most regular instructor-led training courses.
Training information: microsoft access courses · Microsoft.access.courses · VBA training in London

Resolved · Low Priority · Version Standard

Change caption on toggle button depending on underlying record

Ricardo has attended:
Access VBA course
Access Advanced course

by - delegate Ricardo [8 posts] (2007 Jul 6 Fri, 12:16) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	0	FULL
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	6	book now	£450	£485
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Change caption on toggle button depending on underlying reco

by - delegate Ricardo [8 posts] (2007 Jul 20 Fri, 14:58) Reply

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

· Microsoft Access Training Opens Doors
· Access Database Optimization: First Normal Form
· Why consider Access Visual Basic training?
· Learn about Subqueries in Access Courses
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.