Search results

What do you mean add another control for each row? each record will have multiple rows which are unique to that record and are not contiguous in the amount of rows for each record. Can you elaborate a little please so I may better understand what you are suggesting? Thanks, Marty

If you use the expression builder on the Object you're wanting to display the results in, then yes. Example. Form Objects. txtResult (textbox where the calculation will occur) txtValue1 (textbox where a numeric value is stored) Subform Objects. txtValue2 (textbox where a numeric value is...

I would think the expression builder would allow me perform this. However, I'm having no luck getting more than the first row to calculate. =[Purchase Orders Subform].Form!UnitsOrdered*[Purchase Orders Subform].Form!txtPrice What am I doing improperly?

I have a Form, frmPurchaseOrders On this form I have an object txtSubtotal Also, this Form contains a subform which pulls applicable results from tblInventoryTransactions The fields in the subform are txtUnitsOrdered, txtUnitPrice, txtPartNumber, txtTransactionDate, txtItemDescription This...

actualy its Number and I've used table source / row source 'SELECT Accounts.* FROM Accounts;' expression. So I've went to table Accounts and opened it up and the primary key for 6100-0000 is 2 and 6200-0000 is 3. So I changed the code to the following.... Private Sub cboAccount_AfterUpdate()...

Look what happens to the code... This is an anomaly. Private Sub cboAccount_AfterUpdate() If Me![cboAccount] = 6100 - 0 Or _ Me![cboAccount] = 6200 - 0 Then Me![checkTAX] = -1 Else Me![checkTAX] = 0 End If End Sub Why did it turn the 6100-0000 into 6100 - 0 ?

I'm not very good at VBA yet, is this code even close? I know its not right because I get errors. Private Sub cboAccount_AfterUpdate() Me![cboAccount] = 6100-0000 Or Me![cboAccount] = 6200-0000 Then Me![checkTAX] = -1 Else Me![checkTAX] = 0 End If End Sub

However, this one eludes me. On a FORM, I have 2 Objects. A check box and a combo box. checkTax cboAccount I have checkTax set to: YES/NO I have cboAccount functions with a rowsource lookup: SELECT Accounts.* FROM Accounts; Here is the layout... 6100-0000 = NO 6200-0000 = NO 5430-0100 =...