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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate Form Name to Parse for function 1
multiple default value in a field 2
Combo Box 1
Form and default dates 9
How to add 1 (one) to the default value 2
Field Value based on highest value 3
Automatically updating a table with default values 3
Default Data Point 4

Back
Top