Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Exclamation Unanswered: How to retain the last value selected

    I have a database that I do JobCharges for. What my situation is, when doing the data input you first select the JobNumber from a ComboBox for the charge to be based against, then input all the rest of your data. My situation is that when I need to input the next JobCharge(record) and it is for the same JobNumber I have to go select that number all over again. What I would like to do it Keep the last JobNumber for the next entry if that is what is needed. Explain how I can have that same number appear again when it's time to generate the next record.

    thanks in advance
    Bud

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    In a module copy and paste this code.

    Public Function RepeatLastEntry()
    SendKeys "^(')", True
    End Function

    In the DoubleClick event of the Combo Box add this line of code.

    Call RepeatLastEntry

    You will need to have a command button to add a new record for this to work.

    David

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •