Default value disappears for prim key field

[azstyx]

Hello,
MS Access 2000 sp3
When adding a new record to an order file, I have a default value on the ordnum field. It also has a format = "9999\-999". The default value is "0603-".
When the user clicks on the new rec nav button, the form has the correct default in the ordnum field "0603-". However, when the user trys to key in the remaining 3 digit sequence number (.i.e. result 0603-123), the default value disappears as soon as the use startes to type the first character. The table source is a query that links the order table to the customer table via cust num. When i use only the order table as the form source, this works ok, no issues but i see this issue when i am using a query joining two tables.
Does anyone have any ideas why or how I can correct this?
Thanks!!
zip file attached with test database

 

[MStef]

Hello azstyx!

Look at my way for this problem.
"DemoDefaultKeyA2000.mdb".

 

[azstyx]

Hey I checked your solutin and see the afterupdate evnt but my client's requirement is that thye want to see the default value in the order number field and then they add the 3 digit sequence number to it.
thanks!
styx

 

[RuralGuy]

I removed the input mask and added some code to the GotFocus event of the ordnum textbox. Does it suggest some other ideas for you?