[RBG7-L] - Re: Visible Bit Button

[Jan Johansen]

Jan,   Glad to be of help. I get a lot of great ideas from this list and I really am getting in to the property command. Heck my code now looks like a DIALOG here and there, throw in a PAUSE, SET VAR or two, do some DECLARE CURSOR and then a whole pile of PROPERTY commands.   Jan Johansen ----- Original Message ----- From: Jan Barley To: RBG7-L Mailing List Sent: Wednesday, September 28, 2005 8:04 AM Subject: [RBG7-L] - Re: Visible Bit Button Dawn and Jan, Thanks for your quick responses!  I'm still learning with the property commands and having them set on the form itself did not refresh with each new record, but now that I've added the command to the table settings, it works beautifully!  Thanks so much - you saved many a dent in my office walls!!!!!   Jan ----- Original Message ----- From: Jan Johansen To: RBG7-L Mailing List Sent: Wednesday, September 28, 2005 10:45 AM Subject: [Norton AntiSpam] [RBG7-L] - Re: Visible Bit Button Jan,   I have a few buttons that do this. But sometimes I remember to turn them on but forget to turn them off again. Without seeing the details of your eeps try this   SELECT COUNT(SubCategory) INTO vCount INDIC ivCount FROM <TableName> IF ivCount = 0 THEN    PROPERTY <bitbutton> VISIBLE 'TRUE'   ELSE   PROPERTY <bitbutton> VISIBLE 'FALSE' ENDIF   Jan Johansen ----- Original Message ----- From: Jan Barley To: RBG7-L Mailing List Sent: Wednesday, September 28, 2005 7:28 AM Subject: [RBG7-L] - Visible Bit Button Hey all! I am setting up a form for customers and depending on the category, they may or may not have subcategories.  When a category is selected that has subcategories, a bit button appears for the user to select subcategories, but if there are no subcategories, the bit button is invisible.  This worked until I added a DB Navigator bar.  Now, once a category that has subcategories is selected, the subcategory button stays visible thru the rest of the records, even when there are no subcategories. Am I missing some kind of a recalc var somewhere?  The form happens to be a tab form, and I have a recalc var eep on tab change and also on the On After Start.  Thanks!   Jan Barley