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

    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.

    Regards,
    Jim
    Attached Files Attached Files

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

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is 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
  •