Set default value of a field based upon another field (1 Viewer)

June7 · May 18, 2019

If you want to change the actual any time initial is changed, then don't have conditional code, just reset the actual every time initial is changed. As stated in post 12, use initial AfterUpdate event.

To clarify, you are not setting DefaultValue property, you are just filling in a field with some calculated data.

theDBguy · May 18, 2019

HillTJ said:
TheDBguy, go easy on me I'm just a keen newby. What i wish to do is lookup a value, then be able to keep this or amend it and save it in another field. This is for freight cost, where may be a requirement to use a different value to that in the lookup in this instance. If not, the value is prefilled. I thought i'd be able to simply set the default value of the receiving field equal to that of the lookup ie default value = (combolookup) but square brackets.

Okay, I think we can avoid further confusion and get to a solution sooner if you could post a sample copy of your database with test data. Can you?

HillTJ · May 18, 2019

theDBguy, sure can, just bear with me.

theDBguy · May 18, 2019

HillTJ said:
theDBguy, sure can, just bear with me.

That would be great.

Set default value of a field based upon another field (1 Viewer)

June7

AWF VIP

theDBguy

I’m here to help

HillTJ

To train a dog, first know more than the dog..

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread