Results 1 to 3 of 3
  1. #1
    rwahdan@gmail.com is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2015
    Posts
    28

    Lightbulb choose data from table

    Hi,

    I need to choose data from table after choosing value from combobox....example, after choosing a property from combobox, i need to show in the list the related data from other table where the property is equal to the same value i choose from combobox.

    Thanks,
    Rami

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    What sort of form do you have. Look into the combobox onupdate event.


    Sent from my iPhone using Tapatalk

  3. #3
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    the query that provides data for your form needs to reference the combo box.

    your combo box will have the field you want to see and also will have the ID of each record.. even if this isn't visable.

    then your query will also contain the ID field. in the criteria of that field you can do:

    Code:
    =forms!MyForm!MyCombo
    If you want a better answer you need to include more detail or even upload your DB here

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

Similar Threads

  1. how to choose the last row in a report?
    By sumukhreddy in forum Reports
    Replies: 3
    Last Post: 03-24-2016, 04:22 AM
  2. How to choose row heading
    By morerockin in forum Access
    Replies: 6
    Last Post: 09-23-2015, 03:55 PM
  3. Replies: 12
    Last Post: 07-07-2015, 08:12 PM
  4. Can't enter or choose data in form
    By DMJ in forum Forms
    Replies: 3
    Last Post: 05-08-2012, 05:23 PM
  5. Button to choose data type
    By Brother Sharp in forum Access
    Replies: 3
    Last Post: 02-05-2012, 12:05 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