If label blank then input value from another label

[Rgaming]

I have a form of which I want it to automatically input a value into a label when it is blank.


When I click on the add new customer button I need it to automatically take the value worked out and paste it into the customer ID label

A video showing what I need: https://www.youtube.com/watch?v=RN04sZw64_I

The primary ID label is called "Cusomter_ID"
The value that I want to be copied has the label name "Next_Customer_ID"

Any help would be much appreciated.

[June7]

YouTube video won't load for me.

Don't really understand what you mean by 'label when it is blank'. Why would a label be blank? Is this really a textbox?

[Rgaming]

sorry, i meant text box.
essentially I need a validation rule that checks if the text box is empty. If it is then empty I need it to display a value from another text box

[June7]

If you want the box to be editable and bound to field then it cannot have an expression in ControlSource, only a field name.

Why would a textbox need to show the same value of another textbox?

Would require code (macro or VBA) in some event to set the value in textbox.