form startup

[Guest]

I have a table bound to a form. It's a continuous form so when it opens it
displays all of the records.

Is there a way to prevent the query of all of the record when the form opens
but still have the form bound to the table?

Thanks in advance for your help!

 

[Arvin Meyer]

You just about answered your own question. Build a query to reduce the data
and bind your form to that.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

I realize that, but the query would still run returning no rows.

I don't want the query to run at all...is that possible?

 

[John Vinson]

I realize that, but the query would still run returning no rows.

I don't want the query to run at all...is that possible?

You can set the "Data Entry" property of the form to True; this will
allow you to enter new records into the table (or the query) but will
not allow any existing records to be displayed.

John W. Vinson[MVP]