Search results

Glad you have a solution. Always pleased to help if I can :)

Perhaps: TotalQty: Nz([Day1Qty],0)+Nz([Day2Qty],0)+Nz([Day3Qty],0)+Nz([Day4Qty],0)+Nz([Day5Qty],0)+Nz([Day6Qty],0)+Nz([Day7Qty],0)

Take a look at the "similar threads" section below

What is the value of Me.Filter when the code runs

Try: DoCmd.OpenReport "myreport", acViewReport, "", Me.Filter, acNormal

Perhaps you could set the sub form as Not enabled. Then put your validation code in the Main forms Before Update event and in the Main forms On Current event

Can you show us the code that produces the error?

Take a look at Conditional Formatting of Controls(textboxes etc) You will be able to set the backround colour of controls dependent on the value of "Status"

IMHO it would be better to save the month numbers in a separate table.

If the values returned by the UDF are G2, -5, -7 then how would you like them ordered when the label is clicked. -7 is smaller than -5, so -5 would be above -7, but where would you want the text value (G2) to be. Below -7 or above -5

How do you the column if the values returned are G2, -5,-7

Can you post a copy of your db which has a string value being returned in the UDF

Take a look at the attached db. I have changed your UDF to return an integer rather than a variant which I believe solved the problem. I have also changed the SQL statement used in the forms Recordsource so it no longer uses your UDF but does the calculation within the query instead.

I can't replicate the problem. Can you post a copy of the db

You need to add the following line to the GotFocus event of the Product combo: Me.ActiveControl.Requery

Combo Products needs to be bound to the ProductID field. The Row Source property needs to be changed to something like: SELECT tblProducts.ProductID, tblProducts.ProductName FROM tblCategories INNER JOIN tblProducts ON tblCategories.CategoryID = tblProducts.CategoryID WHERE...

The Row Source property of the Product combo should be: SELECT tblProducts.ProductName FROM tblCategories INNER JOIN tblProducts ON tblCategories.CategoryID = tblProducts.CategoryID WHERE...

I'm using A2019 which seems to work without this problem.

What version of Access are you using?

Welcome to the forum John :)