By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,466 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Table column data in a report

P: 16
I have a table with one row and 5 columns. How to display column1 value in the text box of report 1 on opening the report1.
Jan 10 '12 #1
Share this Question
Share on Google+
2 Replies

Seth Schrock
Expert 2.5K+
P: 2,941
Assuming that there will always be only one row in the table, you could put the following in the report's OnLoad event.

Expand|Select|Wrap|Line Numbers
  1. Me.[text box of report 1 name] = DLookup("Column 1's name", "table's name")
If you aren't sure if the table will remain with only one row, you can add criteria to the DLookup() function, but without knowing more about the structure of the table, I can't guess on what it would be in your case.
Jan 10 '12 #2

Expert Mod 15k+
P: 31,492
Bind the report to the table. Create a TextBox control. Bind that to your first field of the table.
Jan 10 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.