Recent content by Peter Mac

I found this interesting article: http://www.mvps.org/access/forms/frm0031.htm I didn't build my forms in the manner they describe though. For example, I have 1. Orders Main Form 2. Order details is a subform of ORders Main 3. Payments is a subform of Orders Main 4. Delivery is a subform...

You must have a lot of faith in me that I can figure out how to solve this problem from that comment :) Interestingly, you did indeed send me in the right direction and I solved the problem. I got to thinking that I could set the value using a macro and a sql statement and that worked. Here's...

On my main form "Orders" I can see subform Order Details like this: =[Order Details].Form!OrderTotal I tried to reverse my logic and allow my "Payments subform" to see my Orders main form like this: =Orders.Form!OrderSubTotal That gave me a #Name? error In my Payments subform I tried using...

I have an "Orders" form that has three subforms: 1. Order Details 2. Payments 3. Shipping I found in my Access book how to make the main Orders form see a calculated totals field from my Order Details Subform. However, I need to share calculated fields BETWEEN subforms. For example, I...

I have a database I'm working on where I need to populate a combo box from the values in a query. The control source on m form is a box called "County" The row source for County is: SELECT [Counties Query].CountyName FROM [COUNTIES QUERY]; Inside the Counties Query I have the criteria...