Results 1 to 10 of 10
  1. #1
    Fish218 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    68

    Field values in datasheet not updating on first record entry


    I have a split form with text boxes and combo boxes in the header that provide values for the datasheet . Some of these fields have assigned default values, some do not. The fields that do not have assigned default values don't populate the datasheet on the first entry, but do on each additional entry. I'm not sure what's going on, I do not have any event procedures on these controls. Any advice would be appreciated.

  2. #2
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    By "split form" - do you mean form and subform? I assume the answer is yes, because a form cannot have a header in datasheet view.

    That said - how do you get the data from your text and combo boxes from the header to the subform fields that do not have assigned default values? Is the subform a data entry form?

    John

  3. #3
    Fish218 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    68
    No it is a split form (which is a way to get a header in datasheet view), but after spending time working on the split form I came to the realization that you can't use a split form as a subdatasheet. So now I am building a subform with text boxes in the header that are the control sources for fields in details. I fixed the issue of things not populating with after update event procedures.

  4. #4
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    Oops - My Bad! Split form is new to A2007 - I only have A2003, so I wasn't aware of it.

    Sorry!!

  5. #5
    Fish218 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    68
    Do you know if I can use two subforms based on the same table?

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Yes, but why would you need to? Not a good idea to allow editing in both.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Fish218 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    68
    I am building a form that has numerous tabs. Each tab is for a different person we enter data on. All tabs will be based on the same table. It's easiest to use the tabs because I can set default values for each person without the data enterer having to do it and limits confusion. Rather than 2 subforms based on the same table, I'm going to try putting text boxes in each tab then use the subdatasheet as a subform with the text boxes providing values for the fields that don't change often in the subdatasheet.

  8. #8
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    That form doesn't sound very workable - how many people do you enter data on? You will end up having to redo the form every time you get another person in the database, and the number of people you have have will be very limited. Or am I missing something?

    Could you not select the person from a combo box?

    John

  9. #9
    Fish218 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    68
    We enter data on 25 people, but there is not much turnover in those 25. Most people will be on the list until they pass away. Some folks have been on the list now for over 30 years. A combo box would be easier, but the tab feature brings it to the lowest level of confusion because you can see everyones name at once - very little opportunity for data to end up w. Folks entering this data may have little to no database/spreadsheet experience and there is minimal time for training.

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Frankly, I don't think does much toward reducing the chance for entering data to wrong name. What the multiple subforms does make easier is the default value set up. So try a couple of tabs for a test. If it works and you like it, go for the rest.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Updating form from datasheet
    By srcacuser in forum Forms
    Replies: 10
    Last Post: 11-16-2011, 12:59 PM
  2. Replies: 2
    Last Post: 08-02-2011, 07:25 AM
  3. Verify values change before updating record
    By gopherking in forum Forms
    Replies: 6
    Last Post: 07-19-2011, 11:46 AM
  4. Updating record based on textbox entry
    By timmy in forum Programming
    Replies: 16
    Last Post: 04-06-2011, 12:05 AM
  5. Updating field goes to wrong record
    By chrismalan in forum Forms
    Replies: 7
    Last Post: 03-20-2011, 08:07 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
  •  
Other Forums: Microsoft Office Forums