 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008Dlookup
In a report, I am trying to have a text box automatically fill itself by referring to fields in a table, where TblDepartments has ID, Department No, Name of Department. This table is linked to TblEmployeeInfo where Department No (from TblDepartments) is linked to ID (from TblEmployeeInfo). I would like the Name of Department to fill in automatiacally when the Department No is shown on report. I have tried the following, but it shows Error. =DLookUp("[Name of Department]","[TblDepartments]","[Department No]=Reports![TblEmployeeInfo].[ID]") Can anyone please help. Thanks. You cannot reference or read a textbox on a report. Report controls do not expose their values to other objects. You can reference controls on a form or fields from a table or query.  SignatureKen Snell <MS ACCESS MVP> > In a report, I am trying to have a text box automatically fill itself by > referring to fields in a table, where TblDepartments has ID, Department [quoted text clipped - 11 lines] > > Can anyone please help. Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.