Search results

Glad you have it working :D

Not sure that "MUST" is quite right. I thought that expressions without them would still work if the field name had NO spaces in it. I would agree that they are advisable though.

If you post a copy of the db one of us may be able to find the problem. The last code that I posted worked when I tested it.

Can you post a copy of the db with just a couple of fictitious records.

Then perhaps: Payer: IIF(IsNull(BillingLastname), Firstname & " " & Lastname & " (Student)", BillingFirstname & " " & BillingLastname & " (Billing)")

Try: Payer: IIF(IsNull(BillingLastname), Firstname & " " & Lastname & ", '" & (Student) & "'", BillingFirstname & " " & BillingLastname & ", '" & (Billing) & "'")

Try: MsgBox ("Wrong Password.", vbInformation + vbOkOnly, "Operation Cancelled")

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.