jmurray125
Technical User
Hi-
I've been searching through these forums for a day or two and have gotten incredibly close to making this work, but I just can't figure out the correct coding for my exception. I hope someone with more experience in code might be able to help me.
I work in publishing and am making a database to track reprint corrections. I need to track them by ISBN. My problem is that we have 4 separate imprints. The format for 3 of the imprints is the same; one is different.
I'd like to have the "ISBN" field in the form change based on what the value of the "Imprint" lookup box is.
The values in the Imprint Lookup are: STER, INNOV, HST, and PUZ. The mask for STER, INNOV and PUZ should be "999-9-9999-9999-9;;*" and the one for HST is "999-9-99999-999-9;;*" The previous posting about US vs. Canadian postal codes got me close, but I just don't know enough to label everything correctly. I've even tried using a check box (with true/false; if/then statements) - but I couldn't get that to work quite right either and would rather not have to use the check box if I can get the conditional lookup to work.
I would greatly appreciate ANY ideas you may have.
Thanks!
Jackson
I've been searching through these forums for a day or two and have gotten incredibly close to making this work, but I just can't figure out the correct coding for my exception. I hope someone with more experience in code might be able to help me.
I work in publishing and am making a database to track reprint corrections. I need to track them by ISBN. My problem is that we have 4 separate imprints. The format for 3 of the imprints is the same; one is different.
I'd like to have the "ISBN" field in the form change based on what the value of the "Imprint" lookup box is.
The values in the Imprint Lookup are: STER, INNOV, HST, and PUZ. The mask for STER, INNOV and PUZ should be "999-9-9999-9999-9;;*" and the one for HST is "999-9-99999-999-9;;*" The previous posting about US vs. Canadian postal codes got me close, but I just don't know enough to label everything correctly. I've even tried using a check box (with true/false; if/then statements) - but I couldn't get that to work quite right either and would rather not have to use the check box if I can get the conditional lookup to work.
I would greatly appreciate ANY ideas you may have.
Thanks!
Jackson
