dlookup error

pot2000

Registered User.
Local time
Today, 07:02
Joined
Sep 23, 2003
Messages
10
I am getting Run-time error 2471
the object doesn't contain the automation object 'x' x being the fabrikant. When running the following

Private Sub Fabrikant_Leverancier_AfterUpdate()

Dim strfilter As String
strfilter = Me!Fabrikant

Me!korting = DLookup("[korting]", "[tblFabrikanten]", strfilter)
Me!PrijsPerEenheidinclBTW = [PrijsPerEenheidexclBTW] * 1.19 * (1 - ([korting] / 100))

End Sub

Can any body help me please
 
Me.korting = DLookup("[korting]", "tblFabrikanten", "[Fabrikant] = """ & Me.Fabrikant & """")
 
thanks its working now
 

Users who are viewing this thread

Back
Top Bottom