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 <[email protected]> To: rbase-l <[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 [email protected]. For more options, visit 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.
