Recent content by EricH

I am trying to get a control to take its Default Value from the VALUE of another control on the same form (lets say CTL2 looks at CTL1). CTL1 (Country) is automatically filled in from a Customers table via a query, and the CTL2 (Ship-To Country) is normally the same country, but occasionally its...

CTL1 is populated from a query which combines fields from a Customers table (CustID, CustName, CustCountry, etc) and another table (call it MainTable). There is a lookup control from which I can select CustName then CustCountry is automatically added. However, I need a separate field for the...

I am trying to get a control to take its Default Value from the VALUE of another control on the same form (lets say CTL2 looks at CTL1). CTL1 (Country) is automatically filled in from a Customers table via a query, and the CTL2 (Ship-To Country) is normally the same country, but occasionally...

Problem solved!!!! I had included the table for the subform in the query for the main form. Thanks for your help.

I have created a form with a subform. When I enter records in the subform (eg 1 record on main form has 3 records on subform)I end up with 3 identical records in main form each with 3 records in subform. Is that clear?? The linked Master Fields & Child Fields looks OK. I'm linking...

I have created a Combo lookup box as many times in the past. The control on a form looks up a Customers Table and lists the CustomerID & Customer Nane, and displays them in the drop down box. So far so good!!! However, when I select a Customer, I get an Error Message "Cannot add record(s)...

I have 2 Option Groups (say OptGrp1 and OptGrp 2), OptGrp1 has a choice of 3 options (1, 2, 3) and OptGrp2 has 2 options (1, 2). I would like to activate (Enable or Visible) OptGrp2 if and only if OptGrp1 Choice 1 is selected, otherwise the OptGrp2 field must remain "Null" It must be able to...