Search results

Will do that. Thanks again. I think I understand now.

I think I understand what you are saying, but I have an additional problem in that most of the time I would just multiply Split1 * Fee based upon what was in the Code1 field. But, at other times, still based upon what was in Code1 it would be necessary to multiply Split1 * Amount (another...

I thought the If Then statement was assigning the value (Split1 * Fee) to TotalA.

I thought what I was doing was returning a value. What might I do to make this return a value?

I have a subreport that has the fields that are in the function code. I created a txtbox called TotalA and hoped to populate it from within the functions output. That is why I thought you said to place the function in the control source box. Thought it would execute from there. Was that wrong?

Wrote this just as a trial function to see if it might work. It is not fully completed as yet. Option Compare Database Option Explicit Public Function SplitTotal(TotalA As Double, TotalB As Double) If Me.CODE1 = "AS" Or "AL" Then Me.TotalA = Me.SPLIT1 * Me.Fee Else: Me.TotalA =...

Have been trying to get a function to act as the control source as you suggested. The Function is simple and has no syntax or other errors but when I place it in the control source property it does not execute. Instead when I try to do a print preview of the report, the first thing that...

Will do.

I will try to do that. Thanks again, you have been a big help.

That is exactly what I thought and my function in that form does nothing. Has no syntax error, but has no output in the text box. Must be something wrong with the function as written. Will attempt to rebuild it. Thanks for the quick reply.

Just getting around to trying this. What is the syntax that is needed to call a function from within the control source properties box?

Thank you for your help with this. I will try to rewrite the code again tomorrow and see if this changes anything. Again, thanks for your help.

Every reference to a control in the code does have a control on the report. I do understand the visible property and have used it before. I do remove the labels associated with each control on the report as I don't need them. Should I leave them on the report in invisible mode? Don't...

Tried the code with me. before all of the [ ] and received a number of syntax and unrecognizable errors. Me. [ ] has worked for me before but somehow it does not seem to be recognized. Is it possible that there is a better way to do this other than the Select Case syntax?

Sorry for my ignorance, where should this code be placed? In the control source?

If Code 1 = AS and Code2 = AF it will not go to the next line is correct. If they are not both true it should look at the next line where Code 1 = Al and code 2 is also AF. It that not true?

Yes, they are the unbound textboxes.

How do I "set the unbound controls" ?

That sounds perfect. I will put the code in On Format. Thanks.

What I want to happen is that based on the code below, different amounts of money will be displayed. This was originally assigned to the control source of the sub report, and then I tried assigning it to OnFocus event of the subreport. Neither one gave any errors on print preview, nor gave any...