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

  • Thread starter Thread starter transcriptlady
  • Start date Start date
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.
 
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.
 

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

Parameter Query on a Form 10
Getting a Form recordset to a Report 4
Access Open Form with WhereCondition 6
Go to specific record on form 4
Query Parameter using multiple options 0
Parameter Form - Combo Box - Parameter Query - Report Problems 1
Go to specific record in a form PLEASE HELP ME :) 1
open form bases on parameter query and goto last record 1

Back
Top