Default Value with IF command - Microsoft Access Forum


	Back to Access Forum Comments List

Default Value with IF command

Asteropi Papadopoulou

2 years ago

I'm trying to set up a Customer Code field based on customer type.
So I set up the customer code to create a default random value, but I want it to alternate the first initial based on the customer type it will be getting from another field.
I realised Default values cannot be dependent on another field as it is autogenerated the moment the new entry is created. However, I still need it to work like that, so is there any way to circumvent that?

	Kevin Robertson @Reply 2 years ago
Dynamic Default

Asteropi Papadopoulou OP @Reply

2 years ago

That doesn't quite work. In this video it starts with a default value which was given by the previous record. But in essence I will probably have to change that in every record and it kinda moots the process

What I want is to start with a completely blank record, then choose my customer type from a bound field box -> feed that to an unbound box to get the first initial -> feed that to my customer code to generat the code with X intial and my bunch of numbers and make it indexed with no duplicates(no idea if it should be bound or not) and then feed that back to my table.

So far I have only managed steps 1-2. I did manage to get step 3, but it's not indexed and it doesn't feed that bcak to the table.

In fact I would like to do the same process with Orders sums. I managed to set up my forms beautifully but it doesn't feed the info back to the tables and I would like to have all the info there.

Any more ideas?

	Richard Rost @Reply 2 years ago
That should all be possible... you'll just need to code it each step of the way. Then when you have the final code, DLookup it to see if it's already in the table. If so, regenerate the random number and try again.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen