Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013

    Unanswered: Value of last record still appear on combobox afterupdate

    Hi, all!

    I'm using MS Access 2010.

    I have a form for adding part.
    1. Same prefix Part ID for same category of parts (eg. C for all types of chair).
    2. Able to add multiple of Part ID in one short (eg. if my first ID is C0005, if input quantity 5, C0005 to C0009 will be saved into database).

    But I have a problem, after the new record has been saved, the value of last record still appear on a combobox (Part Type). I want the Part Type combobox to be cleared in the new record. But I can't spot the problem.

    Thanks a lot if anyone can tell me what went wrong with my vba or setting in the properties of the combobox (Part Type). I have attached the file for your reference.

    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Then set the Combobox Value to Null in a New Record:
    Private Sub Form_Current()
     If Me.NewRecord Then Me.cboPartType = Null
    End Sub

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Tags for this Thread

Posting Permissions

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