GW: Multi combo boxes problem

  • Thread starter Thread starter GW
  • Start date Start date
G

GW

I have a table containing the following:-

Table: Clm
Fields:
CL_Name (PK), CL_Date (PK), Dbl_Amount, Txt_Remarks

Query : qClm
Fields:
CL_Name (PK), CL_Date (PK), Dbl_Amount, Txt_Remarks


I build one form with:-
combo box : Cmb_CL_Name, Cmb_Cl_Date
Text Box : Bx_Name, Bx_Date, Bx_Amount, Bx_Remarks

Problem:-

I want Bx_Name, Bx_Date, Bx_Amount, Bx_Remarks to show record based on
selected value in Cmb_CL_Name, Cmb_Cl_Date for editing purposes. Could
someone show me how to do this?

Sample Data: -

NameA, 01/02/2009, 200.00, X1
NameA, 02/02/2009, 100.00, X2
NameA, 03/02/2009, 300.00, X3
NameB, 04/02/2009, 100.00, B1
NameB, 05/02/2009, 200.00, B2
NameC, 06/02/2009, 300.00, C3
 
Keep the "Cmb_CL_Name" in main form and a sub from with all other fields and
objects.. with Recodsource propert to SECLECT DISTINCT CL_Name (PK) From Clm

Chebge the query to:

SECLECT CL_Name (PK), CL_Date (PK), Dbl_Amount, Txt_Remarks From Clm
Where CL_Name (PK) = Forms![MainFormName]![Cmb_CL_Name]
 
Back
Top