Bill-
And if you don't want the "new" record to appear at all, set Allow Additions to
No.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
<http://www.viescas.com/> http://www.viescas.com/
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Monday, June 25, 2012 6:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Next Record
Hi Bill
form properties: Cycle (Other tab) --> Current Record
default is All Records; I change it
Warm Regards,
Crystal
Access Basics by Crystal (Bill Mosca's site)
http://thatlldoit.com
Free 100-page book that covers essentials in Access
*
(: have an awesome day :)
*
________________________________
From: Bill Singer
I am wondering if it is possible to keep a form from moving to the next
record. I have a form that is based on a query that uses about 4
parameters from a series of Combo boxes. There should only be one record
returned by the query based on any configuration of combo boxes. However,
if the user tabs through the whole form they could cause the form to go to
the next record, which will be blank. The biggest problem is that I think
it will be confusing to the user if everything all of a sudden goes blank
when they move to the next record on accident.
Is there any way to prevent the form from moving to the Next Record?
Thank for all your help.
Bill
MN
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar