Run Time Error 3126

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hi,

Av set up a form that allows users to search the database and when the
appropraite results are clicked on the rest of the info is displayed on
another form. but when i click on the results it comes up with run time
error 3126 invalid bracketing of the name '[tblRefLib.Name_Of_Leaflet]'

ne ides how to sort this...??

fie
 
Yes, remove your error handling, or set in Options to Stop on all Errors.
Click "Debug" and then look at the instruction which raised that error -- if
the answer isn't obvious to you, then post again here... I'd _guess_ that
tblRefLib and Name_Of_Leaflet need to be separately bracketed, as in

[tblRefLib].[Name_Of_Leaflet]

Larry Linson
Microsoft Access MVP
 
Back
Top