Number Not Populating Control Correctly

[libraccess]

I have a pop up form for generating an Order No, Starts at 10000 by using Format /10000 in table and in forms Format property
OK that works but I enter a few details on the popup form and write them to the main table and they all work except for the order number
To exit the popup

Private Sub btnUpdate_Click()
Forms!frmMainDel!OrdNo = OrdNo_ID (being the popup's AutoNumber Primary Key)
Forms!frmMainDel!DateMain = OrderDate (this works)
---
---
End Sub
the popup shows the order as eg..10005 but the main form shows as just 5


any clues anyone

[June7]

Format property setting doesn't change the data. Format function can be used to save modified data.

Want to provide your db for analysis?

[libraccess]

Thanks for your reply
a very quick pared down DB

so the Main form Opens - focus is on the order no button(generator) user is to click, fill out details and click button to exit
the main form is then populated with the details
though my tblOrderNoNIB has its PK starting at 10000 the populated OrderNo control in frmMainDel is not

[June7]

As stated, Format property setting does not change data. This is why I never format fields in tables or use lookups in tables. I want to see the actual value. The true value in OrderNoNIB_ID field is 5, not 10005. Remove the format setting and you will see this. Apply formatting in forms and reports.

[libraccess]

Thanks for your quick reply. I thought the / was toooo easy, it just looked like it worked.
So I have found http://support.microsoft.com/default...n-us%3BQ209696
to start an autonumber at a selected number.
Do you think this is what I need to do?

[June7]

That is an option. The other is to format this value in forms and reports.

[libraccess]

Thanks for your help .I tried the append query and that seems to be all OK, a bit of testing and should be good
Thanks again