Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    1

    Using previous entry as default value in a combobox

    I have a combo box (Combo1) on a data entry form. When I have completed my form and move on to the next record, I would like the value of Combo1 to be equal to the value selected/typed on the previous record.



    For example, say on record 1, I Combo1 = "Hi Mom." When I >* to go to a new record, I'd like Combo1 to already be showing "Hi Mom."

    I know this can be done with text boxes, but can't seem to figure out a way to do it with combo boxes.

    Thanks!
    Phil

  2. #2
    Join Date
    Dec 2006
    Posts
    8
    Handwerk,

    I had a similar question that I managed to figure out using a little bit of simple VB code. Check out my post thats a few lines down from where this one will go. A lot of the fields I have in example there are combo box fields that I autofill in with whatever the last value I used was. Let me know if this helps at all.

    Jack

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

Similar Threads

  1. Previous value
    By yegnal in forum Forms
    Replies: 0
    Last Post: 07-22-2007, 07:51 AM
  2. Link ComboBox to field in a table
    By DrDebate in forum Forms
    Replies: 0
    Last Post: 04-27-2007, 08:03 AM
  3. query based on two combobox
    By datto in forum Queries
    Replies: 0
    Last Post: 04-18-2007, 11:10 PM
  4. Selecting text - ComboBox
    By Numbat in forum Programming
    Replies: 2
    Last Post: 06-05-2006, 05:42 PM
  5. Combobox synchronization in a subform
    By pe_z in forum Forms
    Replies: 0
    Last Post: 02-26-2006, 01:48 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