A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Unbound check box won't check



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2006, 06:58 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Unbound check box won't check

I have a form that lists bank accounts, then specific transaction details for
that account number in a sub-form.

I want to add filtering capabilities to narrow the number of transactions
one is looking for.

On the transaction detail subform, in the header section, I have a number of
radio button frames to and text boxes to allow the user to select their
search criteria.

All of the search stuff is invisible and disabled when the form opens, with
instead a general text label that says "All Transactions For This Account"....

I also have a check box, with the label that says "Search for specific
transactions" -
I have the coding for the check box, so when it's enabled (= -1), the
original label is not visible, and all the search fields and descriptions
become visible and enabled.

I've tried putting the coding in both the "After Update" and "On Click"
events. I've also left all the coding off entirely.

The box doesn't do anything when clicked, ever. It's default value = 0,
it's enabled, visible, unlocked and Triple State = No.

Since I've used unbound check boxes in other headers of other subforms, I
don't think it's that. Is there something specific that might be happening
on the loading of the main form or the subform that I should look out for?
  #2  
Old February 22nd, 2006, 08:05 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Unbound check box won't check

This does not appear to be a real problem. It is done all the time.
Post your code so we can see if the problem is there.

"aemAndy" wrote:

I have a form that lists bank accounts, then specific transaction details for
that account number in a sub-form.

I want to add filtering capabilities to narrow the number of transactions
one is looking for.

On the transaction detail subform, in the header section, I have a number of
radio button frames to and text boxes to allow the user to select their
search criteria.

All of the search stuff is invisible and disabled when the form opens, with
instead a general text label that says "All Transactions For This Account"....

I also have a check box, with the label that says "Search for specific
transactions" -
I have the coding for the check box, so when it's enabled (= -1), the
original label is not visible, and all the search fields and descriptions
become visible and enabled.

I've tried putting the coding in both the "After Update" and "On Click"
events. I've also left all the coding off entirely.

The box doesn't do anything when clicked, ever. It's default value = 0,
it's enabled, visible, unlocked and Triple State = No.

Since I've used unbound check boxes in other headers of other subforms, I
don't think it's that. Is there something specific that might be happening
on the loading of the main form or the subform that I should look out for?

  #3  
Old February 22nd, 2006, 08:09 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Unbound check box won't check

Never mind.... I had the "Allow Edits" switched to "No" to prevent changes to
the transaction details, so that also disabled changes to the values of the
unbound fields, including the check box and radio button frames. I'll
disable and lock the fields in the details.

I had already put together a workaround with a standard button, with the
action based upon the caption, which would toggle on clicks.

I like the checkbox better, so I'm reinstating that one.

"aemAndy" wrote:

I have a form that lists bank accounts, then specific transaction details for
that account number in a sub-form.

I want to add filtering capabilities to narrow the number of transactions
one is looking for.

On the transaction detail subform, in the header section, I have a number of
radio button frames to and text boxes to allow the user to select their
search criteria.

All of the search stuff is invisible and disabled when the form opens, with
instead a general text label that says "All Transactions For This Account"....

I also have a check box, with the label that says "Search for specific
transactions" -
I have the coding for the check box, so when it's enabled (= -1), the
original label is not visible, and all the search fields and descriptions
become visible and enabled.

I've tried putting the coding in both the "After Update" and "On Click"
events. I've also left all the coding off entirely.

The box doesn't do anything when clicked, ever. It's default value = 0,
it's enabled, visible, unlocked and Triple State = No.

Since I've used unbound check boxes in other headers of other subforms, I
don't think it's that. Is there something specific that might be happening
on the loading of the main form or the subform that I should look out for?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Signatures and the "Do not check spelling and grammar" Box Nehmo Sergheyev General Discussion 1 July 6th, 2005 04:03 AM
Getting Spell Check Macro to work Tom Hyland General Discussion 8 January 14th, 2005 06:45 PM
File Check Out System Emily Database Design 3 September 29th, 2004 05:25 PM
Spelling & Grammar Check -- Marked Text Skip Larry Coles General Discussion 1 September 6th, 2004 01:10 AM
Check box used in Macro Kurt Using Forms 2 September 1st, 2004 03:22 PM


All times are GMT +1. The time now is 04:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.