First group, let me apologize for sending this so many times, I had changed the email rule for my incoming R:BASE group emails and was sending them to the wrong folder, SORRY – didn’t think ii was getting here. I gave this a try and still can’t get the where clause to change. I tried both the suggestions to close & open the table and Karen’s suggestion to refresh the table. It was late last night when I tried so I’ll try again later today and report back if I still need some guidance.
Thanks, Paul Buckley From: karentellef via RBASE-L [mailto:[email protected]] Sent: Monday, May 02, 2016 8:02 AM To: [email protected] Subject: [RBASE-L] - Re: Change the Where Clause from a Button on the Form I had sent this befoe, did you see it? Karen -----Original Message----- From: karentellef < <mailto:[email protected]> [email protected]> To: rbase-l < <mailto:[email protected]> [email protected]> Sent: Sat, Apr 30, 2016 8:43 pm Subject: Re: [RBASE-L] - Change the Where Clause from a Button on the Form I've done that! The trick is to change your where clause to say: where column1 = .vValue Set vValue = 'A' before the form, change the variable value within your button, then do a PROPERTY TABLE table REFRESH Karen -----Original Message----- From: Paul Buckley < <mailto:[email protected]> [email protected]> To: rbase-l <rbase- <mailto:[email protected]> [email protected]> Sent: Sat, Apr 30, 2016 7:07 pm Subject: [RBASE-L] - Change the Where Clause from a Button on the Form Good Afternoon, I’m using the latest 9.5(64) and I’d like to open a form normally using: Edit Using Form1 where column1 = ‘A’. Then from a button (or whatever) on the form change the where clause and refresh the data, i.e. where column1 = ‘B’. Any blue’s clues would be greatly appreciated. Thanks, Paul Buckley -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
