AutoNumber causes problem.
I have the format of the AN in Access set as: "Br"0000 and "Sr"0000 in another table.
When displaying their ID, I use:
<%="BR" & Right("0000" & myRS("Br_ID"), 4)%>
When using Querystring only Numbers are picked up which is causing me a problem. Can I include the above code in a variable (if so how)?
How do I get around this? Hope to hear...