Prev: Referencing another field
Next: AllowEdits
From: szag via AccessMonster.com on 30 Apr 2010 17:16
If you are in a form and adding information, then close out or go to a new
for it just saves the record as long as all applicable fields are filled out.
Is there a way to only have a record save if a command button is clicked?

--
Message posted via http://www.accessmonster.com

From: Jeanette Cunningham on 30 Apr 2010 18:54
If you simply hide the form instead of closing it, I think that will prevent
the save.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"szag via AccessMonster.com" <u2885(a)uwe> wrote in message
news:a75249f4b37bb(a)uwe...
> If you are in a form and adding information, then close out or go to a new
> for it just saves the record as long as all applicable fields are filled
> out.
> Is there a way to only have a record save if a command button is clicked?
>
> --
> Message posted via http://www.accessmonster.com
>


From: Tommo on 13 May 2010 04:45
I have a similar problem where I have a picklist of Groups which populates
another picklist of Members with the main body of the form showing the Member
details. If the Group contains no Members the member details are blank i.e.
its a new record. If I then pick another Group Access inserts a new record
with all the fields blank. (The primary key is an autonumber.)
What I want is for Access to only save a record when I clik on my save button.

"Jeanette Cunningham" wrote:

> If you simply hide the form instead of closing it, I think that will prevent
> the save.
>
>
> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>
> "szag via AccessMonster.com" <u2885(a)uwe> wrote in message
> news:a75249f4b37bb(a)uwe...
> > If you are in a form and adding information, then close out or go to a new
> > for it just saves the record as long as all applicable fields are filled
> > out.
> > Is there a way to only have a record save if a command button is clicked?
> >
> > --
> > Message posted via http://www.accessmonster.com
> >
>
>
> .
>
From: Jeanette Cunningham on 13 May 2010 21:35
Tommo,
post back with more details about the tables involved in this form,
picklists and subform to enable us to get a better idea of what you are
doing.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Tommo" <Tommo(a)discussions.microsoft.com> wrote in message
news:70B887D4-CFF6-4E27-884F-C0A8E4FEF5AC(a)microsoft.com...
>I have a similar problem where I have a picklist of Groups which populates
> another picklist of Members with the main body of the form showing the
> Member
> details. If the Group contains no Members the member details are blank
> i.e.
> its a new record. If I then pick another Group Access inserts a new record
> with all the fields blank. (The primary key is an autonumber.)
> What I want is for Access to only save a record when I clik on my save
> button.
>
> "Jeanette Cunningham" wrote:
>
>> If you simply hide the form instead of closing it, I think that will
>> prevent
>> the save.
>>
>>
>> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>>
>> "szag via AccessMonster.com" <u2885(a)uwe> wrote in message
>> news:a75249f4b37bb(a)uwe...
>> > If you are in a form and adding information, then close out or go to a
>> > new
>> > for it just saves the record as long as all applicable fields are
>> > filled
>> > out.
>> > Is there a way to only have a record save if a command button is
>> > clicked?
>> >
>> > --
>> > Message posted via http://www.accessmonster.com
>> >
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Referencing another field
Next: AllowEdits