MDE help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Welthey - 23 Jan 2008 01:22 GMT

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?

Reply to this Message

John W. Vinson - 23 Jan 2008 04:42 GMT

>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:
[quoted text clipped - 14 lines]
>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]

Reply to this Message