A
Ana
Hi,
In a form, I had a combo box which selecting CLIENT_ID would trigger a
report with said client info base on the following expression:
DoCmd.OpenReport stDocName, acViewPreview, , " [CLIENT_ID] = " &
Me!Combo25.Column(0)
Me!Combo25 = ""
I now need the combo to look at two parameters: CLIENT_ID and STATUS_ID
before passing the info to the report.
I added STATUS_ID in the combo query and a second column so that CLIENT_ID
and STATUS_NAME can be displayed. (Select CLIENT_ID, STATUS_NAME,
STATUS_ID..)
I'd imagine I need to do the following?:
DoCmd.OpenReport stDocName, acViewPreview, , " [SOLICITUD_ID] AND
[dbo.TIPO_SOLICITUD.TIPO_SOLICITUD_ID] = " & Me!Combo25.Column(0) and &
Me!Combo25.Column(2)
Me!Combo25 = ""
Any help is appreciated.
TIA
Ana
In a form, I had a combo box which selecting CLIENT_ID would trigger a
report with said client info base on the following expression:
DoCmd.OpenReport stDocName, acViewPreview, , " [CLIENT_ID] = " &
Me!Combo25.Column(0)
Me!Combo25 = ""
I now need the combo to look at two parameters: CLIENT_ID and STATUS_ID
before passing the info to the report.
I added STATUS_ID in the combo query and a second column so that CLIENT_ID
and STATUS_NAME can be displayed. (Select CLIENT_ID, STATUS_NAME,
STATUS_ID..)
I'd imagine I need to do the following?:
DoCmd.OpenReport stDocName, acViewPreview, , " [SOLICITUD_ID] AND
[dbo.TIPO_SOLICITUD.TIPO_SOLICITUD_ID] = " & Me!Combo25.Column(0) and &
Me!Combo25.Column(2)
Me!Combo25 = ""
Any help is appreciated.
TIA
Ana