Run Time Error 3126

[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

 

[Guest]

[tblRefLib]![Name_Of_Leaflet]

 

[Larry Linson]

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