I have a form where DataEntry property is set to True.  When the form 
opens it has no record.  If I add a record, save and add another the first 
record entered is displayed when I scroll back.

What do I do so that as soon as I save a record is no longer visible, and 
the only record visible is the currently unsaved one ?

Hi Howard:

Try opening the form and then manipulating it as a class module:

Private Sub cmdOpenForm_Click()

DoCmd.OpenForm "frmOrders", DataMode:=acFormAdd

With Form_frmOrders
   .AllowEdits = True
   .RecordSelectors = True
   .NavigationButtons = False
   .Caption = "Data Entry Form"
End With

End Sub

This will loose the navigation bars. A new record is displayed when the
user tabs out of the previous, but they can't view saved records.

Best,

Bob



>From: "Howard Stone" <ququmber@h...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] do not display record in a form
>Date: Thu, 19 Dec 2002 14:57:43
>
>I have a form where DataEntry property is set to True.  When the form
>opens it has no record.  If I add a record, save and add another the first
>record entered is displayed when I scroll back.
>
>What do I do so that as soon as I save a record is no longer visible, and
>the only record visible is the currently unsaved one ?


_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

'Course, you could just loose the navigation buttons at design time, but 
doing it in code lets you use the form for other purposes, which is handy. 
If all you want the form to do is allow the user to add one new record, then 
you can turn the navigation buttons off as you open the form.


>From: "Bob Bedell" <bobbedell15@m...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Re: do not display record in a form
>Date: Thu, 19 Dec 2002 18:47:59 +0000
>
>Hi Howard:
>
>Try opening the form and then manipulating it as a class module:
>
>Private Sub cmdOpenForm_Click()
>
>DoCmd.OpenForm "frmOrders", DataMode:=acFormAdd
>
>With Form_frmOrders
>   .AllowEdits = True
>   .RecordSelectors = True
>   .NavigationButtons = False
>   .Caption = "Data Entry Form"
>End With
>
>End Sub
>
>This will loose the navigation bars. A new record is displayed when the
>user tabs out of the previous, but they can't view saved records.
>
>Best,
>
>Bob
>
>
>
>>From: "Howard Stone" <ququmber@h...>
>>Reply-To: "Access" <access@p...>
>>To: "Access" <access@p...>
>>Subject: [access] do not display record in a form
>>Date: Thu, 19 Dec 2002 14:57:43
>>
>>I have a form where DataEntry property is set to True.  When the form
>>opens it has no record.  If I add a record, save and add another the first
>>record entered is displayed when I scroll back.
>>
>>What do I do so that as soon as I save a record is no longer visible, and
>>the only record visible is the currently unsaved one ?
>
>
>_________________________________________________________________
>Tired of spam? Get advanced junk mail protection with MSN 8. 
>http://join.msn.com/?page=features/junkmail
>
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or to 
>unsubscribe send a blank email to 


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail

Suggest looking at the OnDirty Event..  you will see what I mean

Later,
bware

-----Original Message-----
From: Howard Stone [mailto:ququmber@h...]
Sent: Thursday, December 19, 2002 2:58 PM
To: Access
Subject: [access] do not display record in a form

I have a form where DataEntry property is set to True.  When the form
opens it has no record.  If I add a record, save and add another the first
record entered is displayed when I scroll back.

What do I do so that as soon as I save a record is no longer visible, and
the only record visible is the currently unsaved one ?