I have one drop down box called branch and a text box called serial. based on the branch selection, I want to populate serial with that branch plus number. I have created a field in the table numserial(autonumber) along with branch and serial. How do I populate serial with branch+number generated by numserial??