how to correct this code

mana

Registered User.
Local time
Today, 11:08
Joined
Nov 4, 2014
Messages
265
hello

i have the following code but there is an error in it. can you help please? i don't know where my problem is.
thank you

Private Sub cmb_Disponent_AfterUpdate()
' Me.RecordSource = " SELECT * FROM qry_D+1_Bearbeiten WHERE Disponent like '" & cmb_Disponent.Value & "%'"

DoCmd.Requery



End Sub



the error is : the recordsource SELECT * FROM qry_D+1_Bearbeiten specified in this form or report doesn't exist
 
Try this:

Code:
Me.RecordSource = " SELECT * FROM [qry_D+1_Bearbeiten] WHERE Disponent like '" & cmb_Disponent.Value & "%'"
 

Users who are viewing this thread

Back
Top Bottom