Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    York, Pennsylvania, USA
    Posts
    164
    Thanks
    0
    Thanked 3 Times in 2 Posts

    Updating records selected from a listbox (Access97)

    Forgive me if this is a simple question but I'm a new Access VBA programmer and find it so much different than Word VBA.

    I've managed to create a listbox containing enough information to select a record from another table for each item selected in the listbox.

    I can't figure out how to access the record in the other table, update a field then save and close it behind the scenes.

    Can anyone point me in the general direction on how to do this?

    Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating records selected from a listbox (Access97)

    What do you have as code so far?
    Francois

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    York, Pennsylvania, USA
    Posts
    164
    Thanks
    0
    Thanked 3 Times in 2 Posts

    Re: Updating records selected from a listbox (Access97)

    Francois,

    I think it's resolved itself. I was trying to help out someone here who couldn't figure out a way to make it work and all my VBA experience is in Word. She just emailed and said she's got it working. Appreciate it.

Posting Permissions

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