T
tjv1960
Can you set a default value to change with each entry. Example: a sequence of numbers that change on each entry.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
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.
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.
sequence of numbers that change on each entry.tjv1960 said:Can you set a default value to change with each entry. Example: a
T
t1400
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.
A
Allen Browne
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.
a number to be entered in a particular field that can change.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
primary key, but I cannot use zero because it causes duplicates. So, I needt1400 said:Allen - thanks, I'm trying to set this up in the table. I need to set a
a number to be entered in a particular field that can change.