need help: click button to reload record set

[cbnewman]

Suppose you have a form that is generated from the following query:

select * from foo where bar = True (bar of course being a boolean
attribute of table foo)

now suppose that you have a button whose action is to modify the
active record of the form

event onClick( )
Me.bar = false
end

how do you force the form to re-execute the query (i.e. reload, but
with the record that just had its "bar" attribute changed to false so
it should be excluded from the record set)?

--b

 

[Rob Parker]

Add a requery statement after record is modified:

event onClick( )
Me.bar = false
Requery
end

HTH,

Rob