Form based on parameter query only showing one record at a time

T

transcriptlady

I have a form based on a parameter query. I want to be able to only see the
record requested from the parameter query, make any necessary changes, and
then requery the form. When I get to the last field on the form and press
[Enter], I get a blank record. I don't want a blank record, but I want it to
run the parameter query to find a new record.

Any help you can give me would be appreciated.
 
K

Kay

Easiest Way: create a button after the last control...have it run a simple
macro

1st Action: Save
2nd Action: Requery

You can verify that the buttons tabstop property is set to yes and you will
not have to use your mouse to click it. You will just enter through it.
Goodluck.
 
B

Bob Quintal

=?Utf-8?B?dHJhbnNjcmlwdGxhZHk=?=
I have a form based on a parameter query. I want to be able to
only see the record requested from the parameter query, make any
necessary changes, and then requery the form. When I get to the
last field on the form and press [Enter], I get a blank record. I
don't want a blank record, but I want it to run the parameter
query to find a new record.

Any help you can give me would be appreciated.

Set the form's Allow Additions property to NO.
 

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