Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2017
    Posts
    2

    Additional Value List edits erasing previously entered fields

    Any advise would be greatly appreciated. I built a basicdatabase tracking vehicles, it works perfect running locally. After uploadingthe tables to (office 365) Sharepoint,Ihave an issue with value list additions erasing previously entered fields.
    Table
    Click image for larger version. 

Name:	overview table.PNG 
Views:	12 
Size:	7.2 KB 
ID:	29207
    Step 1 add Veh. Mileage, Veh Currently with, Veh Status, Vinthan click on Make.
    Click image for larger version. 

Name:	step1.PNG 
Views:	12 
Size:	5.4 KB 
ID:	29208
    Step 2 add Make GM


    Click image for larger version. 

Name:	step2.PNG 
Views:	12 
Size:	9.3 KB 
ID:	29209
    Step 3 After typing GM Previous field’s erased (note Make GMis now in drop down) same thing happens with Model.
    Click image for larger version. 

Name:	step3.PNG 
Views:	12 
Size:	7.2 KB 
ID:	29210
    [IMG]file:///C:/Users/Ron/AppData/Local/Temp/msohtmlclip1/01/clip_image005.png[/IMG]

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    Why are you using a value list for your vehicle types. That would be a non-normalized database structure.

    What you'd want is a table specifically for vehicle makes

    Code:
    tblVehicleMake
    VM_ID  VM_Description
    1      Ford
    2      Chevrolet
    3      Chrysler
    4      Toyota
    Then store the VM_ID (which is an AUTONUMBER data type in tblVehicleMake) as a foreign key in your data entry table (the one where you're recording the mileage, etc). I suspect you have more problems with your data structure than anything else.

    If you persist in using value lists that is a FORM DESIGN change, you would have to force an update to the ROW SOURCE of your combo boxes then save the form, otherwise all changes are temporary (until you close your form or re-load it)

  3. #3
    Join Date
    Jun 2017
    Posts
    2
    Thank you for your advice and time, I will make suggestedchange to the table and review all other tables that I used Value List in. Obviously, I need to read up on databasestructure.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 11-17-2016, 10:05 AM
  2. How to recall information previously entered
    By Accu-Grind in forum Forms
    Replies: 4
    Last Post: 11-07-2015, 06:34 AM
  3. Replies: 6
    Last Post: 07-10-2011, 05:33 PM
  4. Replies: 4
    Last Post: 05-28-2011, 01:20 AM
  5. Replies: 3
    Last Post: 05-26-2011, 12:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums