Results 1 to 2 of 2
  1. #1
    William McKinley is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    59

    Data Entry Form: Retain Selected List Box Value

    I'm creating a data entry form that will be used for "checking out" customer orders to employees. The form itself is pretty basic; it contains a list box of the employees who will receive the orders, a field for the order number, and a checkout date/time field.



    Everything on the first scan works great, except that the selected listbox value is not retained into the next new record. This is making the process cumbersome for the user as they have to reselect the employee on every record. Ideally, I would like for the user to be able to take several orders, select the associate the orders will be checked out to in the list box, and scan each order number into the database. The data would then populate the table with the order numbers, the person's employeeID, and check out date/time.

    I apologize if this has been answered already, I was unable to find the solution if it exists. If any additional information is required don't hesitate to ask.

  2. #2
    William McKinley is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    59
    Sorry, I guess I should have looked a little harder. Feel free to delete this post if it's redundant.

    Solved using this link: http://www.mvps.org/access/forms/frm0012.htm

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

Similar Threads

  1. Replies: 1
    Last Post: 10-13-2010, 12:40 PM
  2. Data entry form
    By adept in forum Forms
    Replies: 1
    Last Post: 08-20-2010, 10:13 PM
  3. Sub Form Data Entry
    By OldBloke in forum Forms
    Replies: 1
    Last Post: 08-09-2010, 06:58 AM
  4. Replies: 1
    Last Post: 03-15-2010, 02:52 PM
  5. Combo box/list for data entry.
    By geoffishere in forum Forms
    Replies: 1
    Last Post: 03-13-2010, 04:16 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