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

[Mohammad Siddiqali]

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.

[maximus]

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.