Results 1 to 3 of 3
  1. #1
    snipe's Avatar
    snipe is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    287

    Auto-populate a couple combo boxes from previous record?

    Hey guys,



    One of the data entry jobs that my clericals have is to input our "DreamRoom" cards. These cards have the usual info:name, address, etc. Each salesperson turns in 5-30 each day. Up until now, we haven't tracked the salesperson or store with the customers info, so this wasn't an issue. I have redesigned the form. Here's a snip (obviously its a working title):
    Click image for larger version. 

Name:	Screen Shot 2014-08-05 at 4.45.13 PM.png 
Views:	3 
Size:	27.7 KB 
ID:	17666
    The 2 fields in the header (store, salesperson) I want to stay the same, until manually changed. So a clerical can type in the 5-30 cards each day without having to click the store/salesperson each time. What is the best way to do this?

    I put those in the header because I guessed that would accomplish what I wanted. I guessed wrong. What is a form header for?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Use code that sets the DefaultValue property of the relevant controls. Move those controls to the Detail section. Rather common topic in forum.

    The form header is a good place for form title label, as you have done. Also, for unbound controls to input filter criteria that are referenced by code or dynamic parameterized queries and for command buttons.
    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.

  3. #3
    snipe's Avatar
    snipe is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    287
    Ah good to know about the headers. Appreciate it.

    Found this on the forum: http://access.mvps.org/access/forms/frm0012.htm

    Exactly what I am trying to do. Working great!

    Thanks!

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

Similar Threads

  1. Replies: 11
    Last Post: 08-06-2014, 09:47 AM
  2. Combo Box Auto Populate-Applies to EVERY Record
    By AccessNewb11 in forum Access
    Replies: 3
    Last Post: 05-22-2014, 11:45 AM
  3. Replies: 5
    Last Post: 07-19-2013, 03:42 PM
  4. Replies: 11
    Last Post: 01-25-2013, 12:03 PM
  5. Replies: 5
    Last Post: 03-07-2012, 12:57 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