G
gweasel
I've got a form "Frm_Logbook" that has a sub form "Frm_LogbookEntry".
The form gathers information about the client, who took the order,
instructions, total pricing, etc. The subform gets information for
specific jobs with that order (jobs A, B, C, D, etc...). So, any
order will be a single Log #, but could have numerous Log Letters.
How can I have the Log Letter automatically enter/update? It should
always start with "A" and go up from there. Once it gets to "Z",
assuming this ever happens, it should then keep counting but move on
to "AA", "BB", etc.
Is this possible? How can I implement it and where should the code
go? I'm assuming it will use the ASC and or CHR$, but I'm not at all
good enough with coding to know how to use that.
Thanks.
RJB
The form gathers information about the client, who took the order,
instructions, total pricing, etc. The subform gets information for
specific jobs with that order (jobs A, B, C, D, etc...). So, any
order will be a single Log #, but could have numerous Log Letters.
How can I have the Log Letter automatically enter/update? It should
always start with "A" and go up from there. Once it gets to "Z",
assuming this ever happens, it should then keep counting but move on
to "AA", "BB", etc.
Is this possible? How can I implement it and where should the code
go? I'm assuming it will use the ASC and or CHR$, but I'm not at all
good enough with coding to know how to use that.
Thanks.
RJB