Search results for query: *

Text box 53 has =[UnitsReceived]*[Subtotal] Text box 55 in footer has =Sum([Text53])

I check out the FAQ and understand better but now have a new question on my report. I do the calculation on the report with text box statement. =[UnitsReceived]*[Subtotal] but now need to do a total on that field so I inserted another text box in the footer with =Sum([Text53]) but do not...

Ok I did leave it and do have a report that now does the calculation. I don't understand why a change in [Subtotal] ([UnitsReceived] cannot change) would be a problem, it should change in the table just as [Subtotal] would. Sorry but I do not know what a nomilization problem is. Thanks...

I have a subform in data sheet view that gets a total using =[Subtotal]*[UnitsReceived] in the control source But I need this information to go to the table field unit weight How would I do this?

Subform choice is limited by mainform choice with rowsource SELECT DISTINCTROW Products.ProductName, Products.ProductID, Products.NumberPerUnit, Products.WeightPerThousand FROM Products WHERE (((Products.CustomerID)=[Forms]![Purchase Orders]![SupplierID])) ORDER BY Products.ProductName; When...

Boy come back a week later and its even difficult to understand what I wrote, anyway I did get the DLookUp to work you just have to spell DLookUp correctly, also got the column count to work also but neither of these will actually work for me as I need be able to manually change the unit count...

Thanks for the reply but still no go

Ok, I'm new at this but here is what I have. It's subform that is limited by a selection in the main form - this works OK but I need some more fields to fill in on the subform. I first tried in the rowsource of the txtUnitcount = Dlookup("NumberPerUnit", "Products&quot...

Thanks for the response. The first query is stored in a rowsource [ProductId] in a subform called [Purchase Orders Subform]so that query would have to stay the same as it is in a Subform and looking at a control in the Mainform(right??). The second query is stored in a rowsource [UnitCount]in...

I have the subform cmbo which is limited by the selection in the mainform but I need cmbo in the subform to be limited by that subform selection. Do I need to name the form and then the subform also? This works for my first selection. Row Source SELECT DISTINCTROW Products.ProductName...

I have a subform that limits its choice with a query on a combo box in the mainform but need to bring two more fields over. I tried to query the combo box in the subform but thing I am going at this the wrong way. What I want to do is in main form select customer, subfrom limits choice to...

I have a subfrom that runs a query on a cbo in the main form (Pick customer on main form and subform cbo choices are products associated to that customer) but need the subform to requery if the user goes back and changes the mainform cbo. Currently there is a requery on subform on enter and exit...