dbTalk Databases Forums  

Creating new record with default values

comp.databases.ms-access comp.databases.ms-access


Discuss Creating new record with default values in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jerome g
 
Posts: n/a

Default Creating new record with default values - 12-01-2004 , 03:41 AM






Hi,

I'm trying to use a (simple) form to create a new record, with all
values being default values coming from a previous form. My problem is
that I can save that new record only if I change one of the default
values, something which is not supposed to be done. So is there a way
to create the record without making any change to the 'default form'?
Thank you for your help!

JeromeG

Reply With Quote
  #2  
Old   
Bas Cost Budde
 
Posts: n/a

Default Re: Creating new record with default values - 12-01-2004 , 04:22 AM






jerome g wrote:
Quote:
Hi,

I'm trying to use a (simple) form to create a new record, with all
values being default values coming from a previous form. My problem is
that I can save that new record only if I change one of the default
values, something which is not supposed to be done.
Why do you want to store the record with exactly the same values as the
previous?

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea


Reply With Quote
  #3  
Old   
Ed Robichaud
 
Posts: n/a

Default Re: Creating new record with default values - 12-01-2004 , 09:41 AM



If you have a key/index set to "no duplicates" (as you should) then Jet will
not let you have two identical records. If you really must have the same
info multiple times (and I can't think why you would), add an autonumber
field to your table and form and remove any other unique index. You then
can save two (or more) records that have the same values in all fields,
except the autonumber.
-Ed

"jerome g" <jgathon (AT) yahoo (DOT) com> wrote

Quote:
Hi,

I'm trying to use a (simple) form to create a new record, with all
values being default values coming from a previous form. My problem is
that I can save that new record only if I change one of the default
values, something which is not supposed to be done. So is there a way
to create the record without making any change to the 'default form'?
Thank you for your help!

JeromeG



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.