Results 1 to 4 of 4
  1. #1
    sephiroth2906 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    73

    Record source in form not updating

    Hello folks!



    I have a form that I use to enter employee late arrivals. The employee name on the form is a combo box that is bound to a table that the information goes to, and the employee name in the table is bound to a query which finds active employees, and the in the table the employee name field is limited to the employee name field in the active employee query. The active employee query gets information from and employee master table.

    Long story short (too late) the combo box is limited to what is in the employee name field in the active employee query. I just added a new employee and need to put information into this table, but while I can see the employee is on the active employee query, I cannot choose them from the combo box on the form, nor can I choose or enter them onto the late arrival table itself.

    What have I screwed up and how do I fix it?

    Thanks!

  2. #2
    bigroo's Avatar
    bigroo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jan 2012
    Location
    Austin, Texas
    Posts
    101

    Record source in form not updating

    Hi ephiroth2906,

    You will need to re-query after adding the new employee to show up in the combo box.

    Can you post a sample DB with dummy data?

  3. #3
    sephiroth2906 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    73
    Gosh darnit. I am so sorry for wasting everyones time., I forgot to update a field. I got it fixed now. Thanks for the help.

  4. #4
    bigroo's Avatar
    bigroo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jan 2012
    Location
    Austin, Texas
    Posts
    101

    [Solved] Record source in form not updating

    Hi sephiroth2906,

    I am glad you got it too work!!

    Don't feel you are wasting everyone's time, sometimes good to talk through an issue you are having and someone else can can see the solution!!

    Thanks

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

Similar Threads

  1. Replies: 3
    Last Post: 08-31-2011, 09:37 AM
  2. Form Record Source - Best practices.
    By ser01 in forum Forms
    Replies: 1
    Last Post: 06-11-2011, 11:32 AM
  3. Resetting Record Source on Form
    By Cheshire101 in forum Programming
    Replies: 5
    Last Post: 05-05-2011, 08:52 AM
  4. Replies: 2
    Last Post: 11-29-2010, 11:16 AM
  5. Changing the record source in a form
    By lmichaud in forum Forms
    Replies: 1
    Last Post: 07-09-2006, 09:20 AM

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