I have multiple ID types (FEIN, SSN, and 2 different internal department numbers) which can be used as the ID for a case (not the primary key. Primary key is a autonumber). However each of these have their own distinct format. When printing a summary sheet for each case, we want the ID type "FEIN," "SSN," "Cert," or "BP" printed and then the formatted value for that ID type.
I had this working pretty well up to a point. When adding a new record, I determined the id type, based on whether the user populated the FEIN field, the SSN field, the "Cert" field or the BP field, and saved the literal ("FEIN," "SSN," "Cert," or "BP") to a field called "id type" and then copied the value from the specific fields to a second field called "id text" and used the appropriate input mask based on the id type. So far, so good.
HOWEVER, when I was updating an ID (presuming that it had been entered incorrectly), I could not get the ID type field and ID text field to update correctly and format correctly.
I'm not sure if all this manipulation is the way to go,,,, or if there is a way to do some code or unbound fields on the summary sheet, that will pick up the field that has data in it and the appropriate formatting.
Thanks in advance!!