Results 1 to 2 of 2
  1. #1
    Mohammad Siddiqali is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2011
    Location
    India
    Posts
    2

    How to get all the records of a specific person from table to form by using macros

    Dear All,


    This is siddiqali working on web access 2010,For the first i am working on access so facing some problems .I am suing access 2010 macros and completing my task.I need some help from you .I have a table that contains customer products andand i named this table as customer product table each customer will have many products http://picasaweb.google.com/lh/photo...directlink.And in the order form when i select the customer i should get all the products of customer from customer product tale to from.http://picasaweb.google.com/lh/photo...eat=directlink.

    I hope some one will respond to me ,If any one wants more clarification they can send interact with me by sending mail to me my mail-id is mdsiddiqali@hotmail.com

    Thank You,
    MD.SIDDIQALI.

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Let me illustrate the solution with a small example I have a simple database with two tables

    Table2
    Table3

    Table2 has the following Feilds:
    User_ID (PK Autonumber)
    User_Name

    Table3 has the Following Feilds:
    ID (PK Autonumber)
    User_ID (FK Number)
    User_Level

    I have made a Tabular Form using Table3 and I have another unbound Form Form1 with a combobox Combo1 with its Rowsource set to table Table2.

    Now when I select a user in the Combobox in Form1 the user Level is displaped in the Form Table3 which is a subform in Form1.

    How this is achieved:

    In the Recordsource of Form Table3 I have used the query Builder to build a query setting the criteria of User_ID = Forms!Form1!Combo0

    and I have placed this simple code in the Afterupdate event of the combobox to Requery the form and display revelant data.

    Me.Table3.Requery


    Please refer to the small sample attached.

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

Similar Threads

  1. Transpose specific records to table (VBA)
    By KP_SoCal in forum Programming
    Replies: 2
    Last Post: 02-27-2013, 09:31 PM
  2. Replies: 21
    Last Post: 11-21-2010, 12:01 PM
  3. Combined "person" field on form
    By Remster in forum Forms
    Replies: 14
    Last Post: 09-15-2010, 10:44 AM
  4. New person here AND with Access
    By Coytee in forum Access
    Replies: 8
    Last Post: 03-08-2010, 01:36 PM
  5. Replies: 0
    Last Post: 02-24-2010, 12:56 AM

Tags for this Thread

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