Search results for query: *

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

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...

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...

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...