How to set up a default value of a field based on the same field .

T

Tony

Hi There,

Is there anyone knowing "How to set up a default value of a field based on
the same field"?

Thanks
 
T

Tim Ferguson

Is there anyone knowing "How to set up a default value of a field
based on the same field"?

Not sure what this means, but the answer is still, "You can't".

Default values are assigned to fields at a time before _any_ of them have
any values -- it's an empty record.

What you probably should be able to do is to use the AfterUpdate event of
some control on the form to calculate the value you want inserted in the
other one. Be aware, however, that this question often a cover up for a
likely Design Error, for example storing "redundant" data.

Hope that helps


Tim F
 

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

Top