Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78

    Unanswered: Sync subform with listoox

    I have a list and a subform on a form. I want the current record on the sub form to be the selected item on a list. So either by clicking on the list or selecting the record in the subform.
    Attached Thumbnails Attached Thumbnails listandsub.jpg  
    the light is on, someone is home, but they dont know they are. HELLO!

  2. #2
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100
    use the onclick event of the list box and create a recordset clone based on the value from the list box and use the "bookmark" property to display the details on the sub form.

    I can show you the code if needed.
    Access XP & WinXP Pro

  3. #3
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100
    s*** I just realised that I read your post wrong - I was reading it the wrong way round.

    You could place some code in the oncurrent event of the sub form that changes the record source of your list box then requery the listbox
    Access XP & WinXP Pro

  4. #4
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78
    Originally posted by xander
    use the onclick event of the list box and create a recordset clone based on the value from the list box and use the "bookmark" property to display the details on the sub form.

    I can show you the code if needed.
    If you cpould show me the code that would be great..... i'm running out of time on this one!!!
    the light is on, someone is home, but they dont know they are. HELLO!

Posting Permissions

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