Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box Issue (Access 97)

    I have a combo box which the user selects a number from from the list. The problem I am having right now is once the user makes the selection, it goes to a new record. What must I do to prevent that?

    Below is the code that is in the AfterUpdate Event of the combo box.

    Me!txtDMaxNewNum = Me!TrackerNo
    Me!txtNextNum = Me!txtDMaxTN + 1
    Me!txtNewNum = Me!EIN
    Me!CallDate = Now()
    DoCmd.OpenForm "frmEIN", acNormal, "", "", , acNormal

    Thanks for your help.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Combo Box Issue (Access 97)

    You haven't provided enough information. What do you mean, it goes to a new record? Are you talking about a new record in the current recordset, a new record in the form being opened, or something else?
    Charlotte

Posting Permissions

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