Results 1 to 3 of 3
  1. #1
    hlcarlin is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    12

    on change select record?

    Hello, I was wondering how I could arrange a form so that there could be a drop-down box that the user has control of and depending on which value is selected, the reste of the items on the same table row as this value would appear to be edited? Basically, I would like to let the user do record browsing by using this dropdown text box instead of the record arrows at the bottom of msaccess.



    Thank you

  2. #2
    hlcarlin is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    12

    on change select record?

    Hello,

    Im trying to set up an event where when the user changes the selected value in a drop-down box, the rest of the form changes to that particular record in the table. How would I do this? thank you

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    If the form is bound to a table/query, then just create a new combo box using the Access wizard. Access will write the code for you
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Record Count/Change
    By TPH in forum Queries
    Replies: 3
    Last Post: 06-21-2011, 03:19 PM
  2. Trying to fire event on record change
    By danielhowden in forum Forms
    Replies: 3
    Last Post: 05-13-2011, 06:30 AM
  3. Allow change to a field on new record only
    By Grooz13 in forum Forms
    Replies: 4
    Last Post: 08-16-2010, 11:36 AM
  4. Select a certain field of a record based on ID
    By cesarone82 in forum Access
    Replies: 3
    Last Post: 06-06-2009, 01:16 PM
  5. Replies: 4
    Last Post: 05-12-2009, 01:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums