How 2 Set The Parameter???

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

Faraz A. Qureshi

What would be the appropriate syntax so as to have subform's combobox reflect
the entries pertaining to a single account.

The Parent/Major form itself consists of fields like:
1. AccNo
2. AccNm
3. Client

The subform has:
1. Date
2. Client
3. Account (The Combo Box)
4. Amount

I want the subform's field "Account" reflect only those choices of AccNm
where the Parent' field Client & Subform's field Client is equal.

What might be wrong with the following?

SELECT Parent.AccNo, Parent.AccNm
FROM Parent
WHERE (((Parent.Client)=Child.Client));
 
I think you may have it backwards. The main form, chooses the Client and it
should be linked to the subform on ClientID. If the Link Master/LinkChild
property is set for the subform control, no further query is necessary to
have the subform data match the Client in the main form.
 
Back
Top