next data entry from query

[Karen]

I have a form based on a select (distinct) query to allow for data entry on
to a subform. It works for each query that I try, but I would like to
continue to another record (using the query again) without having to close
the form and open it again. How is this done?
thanks

 

[Arvin Meyer [MVP]]

Place a command button on the form with:

Me.Requery

in the button's Event Procedure.

 

[Karen]

thanks I'd been beginning to think about that!
The only way i've been able to get it to work is as
=[Forms]![myformname].[Requery]
but the pop-up box doesn't disappear after bringing up the new record. Any
way to stop this?
thanks

 

[Karen]

have also discovered shift+f9 works.

thanks I'd been beginning to think about that!
The only way i've been able to get it to work is as
=[Forms]![myformname].[Requery]
but the pop-up box doesn't disappear after bringing up the new record. Any
way to stop this?
thanks

Place a command button on the form with:

Me.Requery

in the button's Event Procedure.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com