Search results

Bah, Figured it out. 2 & "Select " & newCompID & " As CompID, QuoteID, Quote_rev, MoreStuff FROM tblComponents " _ Thanks for stopping by. Grem

I am stuck. I have a parent-child-grandchild applet I am working on. The user wants to be able to duplicate items at the child level and have it create the grandchild records as well. The parent record is keyed on Quote_No and Quote_rev The Child Records would be keyed on QuoteID, Quote_rev...

Thank you. That put me on the right track. My query is huge but I got it to work. I fear it may have performance issues when the data records get much larger. There are several DSUM in the query. Any idea that might help with performance? Thanks Grem

I can use the Control Source to calculate the fields in the Children correctly. Is there a way to set a control source to both a field in a table and a calculation?

I have a parent form with a one to many relationship to a subform. The parent form has an unbound text box that is recalculated via the Control Source of the object (we'll call it TB1). The Subform has a Qty (QTY) value and I want to recalculate another subform field (SFF1) based on whether a...

Thank you for the reply. I had tried those. I have this code working on Subform2 when the Qty is updated (also call this event if qty is clicked). I used the pub variables to pass from Parent to Child. If Qty > 0 Then Me.txtWOQtyBreak = [pubPriceMargin] + ([pubTotSetupCost] / [Qty])...

Greetings, I have a form with a subform in a navigation menu. Something like: Navigation Form NavigationSubform ParentForm (header data and some unbound calculation fields) Subform (Multiple lines tied to query) I have some fields in the ParentForm (i.e PF1, PF2) that would...

Thanks again. I was able to get it to work within the query design. Thanks again for the lead!

Thanks JHB. The IIF was the path I thought I needed to pursue. I attempted to put something similar in the "Grouping and Sorting" area of the report. Where would that go belong in the query? Or would I put all of the IIF statement in place of the status field in the SQL? Btw, I am working...

I have a working report which groups by a status field. Let's say I have Status (AA, BB, CC, DD, EE). It is grouping and summarizing fine. I would like to be able to merge some groups. So I would like to be able to Group on (AA/CC, BB, DD/EE). What would be the best way to approach this...