Results 1 to 3 of 3

Thread: SubForm problem

  1. #1
    Join Date
    Aug 2003
    Posts
    42

    Unanswered: SubForm problem

    I am using a subform as a datasheet to collect records. I have a global variable which is a claim number. Before opening the subform I set the default value in the source table to the global calim number and then open the sub form for the user to enter data. The problem is when records are added the claim number does not show up as it should. It shows up as a random number that is nothing like the claim number the default value is set to. Any thoughs on how or where I could be losing the claim number I want or why it's being converted to something else each time a new record is entered?

    Thanks in advance.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    In your table...is the claim number a AutoNumber data type?

  3. #3
    Join Date
    Aug 2003
    Posts
    42
    No, it is set to text. I copied the field from another table so they all have the same property settings.

Posting Permissions

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