[RBG7-L] - Re: Visible Bit Button

[Jan Johansen]

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