need help: click button to reload record set

C

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
 
R

Rob Parker

Add a requery statement after record is modified:

event onClick( )
Me.bar = false
Requery
end

HTH,

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top