Unanswered: HELP! How to copy textbox text into the same blank textbox after new record chosen?
I have a textbox on a form called Address_1. When a new blank record is selected on the form I want the contents of address_1 textbox to be copied into the now blank textbox so I dont have to keep on re-typing it in everytime i click for a new record.
It is for a job database, so when people move positions, their job description changes, but their address stays the same.
The form is called Details, and is linked to the table Details.
Yes im re-entering the addresses. I know its not good practice, but its what has been asked for at the moment. Any way of automating it? Otherwise I will just link a new Address table to the Job details table.
The other thing you could do is use the forms tag property to hold the contents of the text box and then spit out the tag property into the new record's text box. You'd have to use a couple of different events. Just a thought.
I initially was going to say just make the default value to that address. but not every person lives at 123 Main St for example...How much information are you inputting that's the same? Name, date of birth, home phone, etc? Or just the address. You could maybe set up a combo box displaying their name, and after you selected a name from there the appropiate name, # etc is automatically filled then you just have to input or change the address...
Click the mouse. the cursor appears.
It flashes a bit.
Hold the Control key down (Ctrl)
Press the key marked '
Release the control key.
The last address entered apprears.
If you want the address that matches a particular name it's more difficult, and we'd need information on how you're storing the name (fullname, forename and surname etc,) and if there are any other unique identifiers.