next data entry from query

  • Thread starter Thread starter Karen
  • Start date Start date
K

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
 
Place a command button on the form with:

Me.Requery

in the button's Event Procedure.
 
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
 
have also discovered shift+f9 works.

Karen said:
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


Arvin Meyer said:
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
Click to expand...
Click to expand...
 
Back
Top