Requery a form

J

Jorge Ribeiro

Hello

I've a bound form with specific query like "select * from customers", and
inside the
form several bounded controls to recordset fields... so far so good

Now i want to have a property that when set would make my form requery showing
the result of "select * from customers where idCustomer=123" (where 123 is
the property received value)

How can I do this?!

And another thing: when i first open the form, if parent form doesn't call
that property, i need that form to jump to a new record... is this possible?

Kind a urgent demand here

best regards

Miguel
 
T

Tom van Stiphout

On Tue, 18 Nov 2008 02:00:01 -0800, Jorge Ribeiro

Me.Filter = "idCustomer=123"
Me.FilterOn

-Tom.
Microsoft Access MVP
 

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

Top