Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Ohio
    Posts
    50

    Unanswered: Unbound forms and unlinked tables ACCESS 2000 ADO

    Access 2000 ADO

    I hava attached a folder with 2 databases in it. CustomerDATA.mdb and Customer.mdb.

    CustomerDATA.mdb has 2 table in it. tCustomers and tUsers

    tUsers records

    UserID PK UserName
    1 Hooks1
    2 Jim2
    3 Bob3
    4 John4

    Customer.mdb has but 1 form.

    I want to be able to connect to the CustomerDATA.mdb database and retrieve, add, edit, delete and save records with unbound forms and unlinked tables. I am able to do this but the value in the combo box is wrong. I have a 2nd record set to fill the value of the combo box.

    For instance - Say I save Hooks1 in the combobox of the first record and save the record. The table is updated with the correct data but the next time i view the record then Jim2 is displayed in the combo box even though it should say Hooks1. If I save Jim2 in the combobox then Bob3 is displayed the next time I view the record. I always adds 1 to the primary key.

    I am trying to do this database properly and proffesionally. I figured completely unbound forms and unlinked tables was the way to go. Please Help



    Thanks
    Access 2000 ADO

    Extract the .zip file to C:\
    so that all of the connections strings will work.
    Last edited by hooks; 08-16-04 at 21:47.

  2. #2
    Join Date
    Oct 2003
    Location
    Ohio
    Posts
    50
    Anyone Please?

  3. #3
    Join Date
    Oct 2003
    Location
    Ohio
    Posts
    50
    I figured it out. Thanks

Posting Permissions

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