Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Maryland, USA

    Unanswered: Default value disappears for prim key field

    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?
    zip file attached with test database
    Attached Files Attached Files
    Last edited by azstyx; 03-16-06 at 17:20.

  2. #2
    Join Date
    Mar 2004
    Berlin, Germany
    on entering a field access marks the contents which is already in .. if u start to type the selection is replaced .. so u hav to set the selection of the text box manually (short program) on the onEnter event of the textbox

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts