Recent content by mdrogan

Ok, This is what I've got so far. Private Sub ProductID_AfterUpdate() On Error GoTo Err_ProductID_AfterUpdate Dim strFilter As String ' Evaluate filter before it's passed to DLookup function. strFilter = "ProductID = " & Me!ProductID Select Case [Forms]![Sales...

Ok, sounds good so far. But how would I refer to the PriceLevel ID in my bound CustomerID combo box on my main form Invoice so that the in the ProductID pricelevel/case is derived from that value of the main form combo? Thanks.

Forms: Products, Customers, Invoice, Subform: Invoice Details. Customers are categorized as Wholesale, Retail, & Distributor Products have three price levels. Wholesale, Retail & Distributor. In the main form Invoice, I have a combo lookup of CustomerID with a price level column. In the...

ME TOO! I would love a copy as well. mdrogan@hotmail.com

I have two forms in question. Invoices and Invoice Details subform. The records are stored in another table called Inventory Transactions. Default value of InvTransDate = Invoice date on the main form. My problem is that when I change the date on the main form, only the first record on the...

I would like to to perform a manual calculation in a number or currency field. I want to use my number key pad to give me a drop down list to act as an adding machine, (ie. adding, subtracting, multiplying and dividing) Once complete, press enter to insert to total. Can it be done with...

I finally assigned fot the default unit in the details section of my Purchase Order form based on the lookup value of my Item combo box. Now everytime I open my form, it flickers. What do I do to stop the flickering? Thanks all.