Formatting

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I have an autonumber that is formatted with a prefix for example on a form
the record number would be DMR0000001 etc.
My question is how do I get the table to save this value.

Also I have a second form that is created via a command button on the
original form and transfers this number to the form in a reference number
control but for some reason it only transfers the number such as 1 instead of
DMR0000001

Thanks
 
I have an autonumber that is formatted with a prefix for example on a form
the record number would be DMR0000001 etc.
My question is how do I get the table to save this value.
Click to expand...

Why would you want to?

If every record contains the exact same text string DMR then there is no point
in wasting table space with it. Just use a Long Integer field in the table
(*not* an Autonumber, as autonumbers will always have gaps and can become
random). Use a format to display the DMR but don't bother storing it.
Also I have a second form that is created via a command button on the
original form and transfers this number to the form in a reference number
control but for some reason it only transfers the number such as 1 instead of
DMR0000001
Click to expand...

That's because the field CONTAINS 1. Don't confuse data *display* - controlled
with formatting - with data content.

I would strongly recommend using a Form and Subform for related tables, rather
than the more complex synchronization of forms using VBA code.
 
Back
Top