Input Value based on another textbox value

[dude19]

I have a report that I am trying to simplify and am running access 97
There is a qry to pull the type of material and is set by the control source.

Now I want another textbox (textbox2)to fill in a value on my report based on the type

So if Type A then value = 7
Type B then value = 8
etc......



If qrytype = "A" Then
textbox2.value = "7"
Else
If qrytype = "B" Then
textbox2.value = "8" etc,,,

^that is what I tried and it never showed a value, I am not sure of the order of how things are run programming wise. I searched around and found after update but that seems like it is used for later versions of access?

any help?

[TheShabz]

The issue is that you aren't referencing the form. Use Me.ControlName if the control is on the same form or Forms!formName.ControlName if on a different form. Also, no need for .Value as it is implied in vba. Me.txtbox and Me.txtbox.value are the same thing. Also, I prefer a switch statement (Select Case) instead of imbedded IF statements.

select case Me.qrytype
case "A"
me.txtbox2 = 7
Case "B"
me.txtbox2 = 8
...
End Select

[ketbdnetbp]

If the report is based upon a query, and that query contains the field [Type], you could just add a calculated field to the underlying query and then, pull that control to the report.

You could try something like this:

xValue: IIF([Type]="A",7,IIF([Type]="B",8,0))

All the best,

Jim