MDE help

[Welthey]

I'm trying to configure my MDB file to an MDE file. When I run the Compile
on my code it is giving me an error on the following code:

Private Sub cboBannerLabel_AfterUpdate()
Me.txtReportName = DLookup("[Report Name]",
"[tblAMUDailyRptsMatrix]", "[Banner Label]='" & Me.cboBannerLabel & "'")
Me.txtJobName = DLookup("[Job Name]", "[tblAMUDailyRptsMatrix]",
"[Banner Label]='" & Me.cboBannerLabel & "'")
Me.txtQueue = DLookup("[Queue Data Goes In]",
"[tblAMUDailyRptsMatrix]", "[Banner Label]='" & Me.cboBannerLabel & "'")
Me.txtDeliverTo = DLookup("[Deliver To]", "[tblAMUDailyRptsMatrix]",
"[Banner Label]='" & Me.cboBannerLabel & "'")
Me.txtPrimaryContact = DLookup("[Primary Contact]",
"[tblAMUDailyRptsMatrix]", "[Banner Label]='" & Me.cboBannerLabel & "'")
End Sub

I am getting the error at the Me.cboBannerLabel. Is there something that I
need to change in order to allow the complile to complete?

 

[John W. Vinson]

I'm trying to configure my MDB file to an MDE file. When I run the Compile
on my code it is giving me an error on the following code:

Private Sub cboBannerLabel_AfterUpdate()
Me.txtReportName = DLookup("[Report Name]",
"[tblAMUDailyRptsMatrix]", "[Banner Label]='" & Me.cboBannerLabel & "'")
Me.txtJobName = DLookup("[Job Name]", "[tblAMUDailyRptsMatrix]",
"[Banner Label]='" & Me.cboBannerLabel & "'")
Me.txtQueue = DLookup("[Queue Data Goes In]",
"[tblAMUDailyRptsMatrix]", "[Banner Label]='" & Me.cboBannerLabel & "'")
Me.txtDeliverTo = DLookup("[Deliver To]", "[tblAMUDailyRptsMatrix]",
"[Banner Label]='" & Me.cboBannerLabel & "'")
Me.txtPrimaryContact = DLookup("[Primary Contact]",
"[tblAMUDailyRptsMatrix]", "[Banner Label]='" & Me.cboBannerLabel & "'")
End Sub

I am getting the error at the Me.cboBannerLabel. Is there something that I
need to change in order to allow the complile to complete?

Care to tell us what error it's giving? Is there in fact a control on this
form named cboBannerLabel? Check the spelling of the control's Name property.

John W. Vinson [MVP]