Subform3 Combo Box Criteria from a subForm2 1

[molly]

Attached is a simplified Contacts file. I am trying to make a ContactsID field on a 3rd subform to use the available contacts from a subform2 for a given AccountID.

The main form has the AccountID for the many customers.

So in the 3rd subform, on that ContactID field, on the record source row, on the criteria row, I tried:

Forms![subform1]AccountID
(attached file has more elaborate subform name)

I did not know what kind of After Update commands to make it fire up. I don't get any contacts to choose from.

I probably did not explain my question well. If you get a moment, please try this mini file, going to the last tab called "calls" and try and pick a cboContactID2 person.

If you can. thanks.

 

[PHV]

The syntax is like this:
Forms![mainform name]![subform control].Form!AccountID

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[molly]

thanks PHV. I still have a problem but i will try another way. I just cannot get the contactID on the Calls tab to see which AccountID is involved and allow me to pick the contactID for the visit. almost works but not quite so.

Molly

 

[molly]

To PHV. May i try this question another way? Sorry for not being so precise in the question. I am recovering from foot surgery and have pain killers going on right now !! really.

i made a newer shorty sample contacts file. Assuming that you or someone could see what i mean better. But i don't want to be pushy.

On my Calls Tab and in the first subform there is a combo field called contactID.

Presently, when i down click it, i see every Contact person in the file. But i only want to see the contacts who pertain to the business account.

EG Abbey Lumber has 2 contact names. when i am in the Calls tab, i would like to see ONLY their 2 contact names. Alas, i see everybody.

Any ideas on how to fix this? File Contacts28 attached. thanks Molly