Default Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you set a default value to change with each entry. Example: a sequence of numbers that change on each entry.
 
You could set the DefaultValue property in the AfterUpdate event of the
form.

However, it would probably be more efficient to set the value of the control
in the form's BeforeInsert event instead.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

tjv1960 said:
Can you set a default value to change with each entry. Example: a
Click to expand...
sequence of numbers that change on each entry.
 
Allen - thanks, I'm trying to set this up in the table. I need to set a primary key, but I cannot use zero because it causes duplicates. So, I need a number to be entered in a particular field that can change.
 
No. You cannot do that at the Table level.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

t1400 said:
Allen - thanks, I'm trying to set this up in the table. I need to set a
Click to expand...
primary key, but I cannot use zero because it causes duplicates. So, I need
a number to be entered in a particular field that can change.
 
Back
Top