Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying data from form on report

Status
Not open for further replies.
Asspin

Asspin

Technical User
Jan 17, 2005
155
US
So I have a combobox on a form with 2 columns in it. The report needs to get the data that is currently selected and in column 2 of that box. This is what I am using for my control source for the text box in my report, but it doesn't work. I imagine I just have this formatted wrong?

Code: 
=[Forms]![fReporting]![comLocation]![Column(1)]

Dan
 
Sort by date Sort by votes
Well sheesh, I was right, nevermind! :)
Off to get caffeine!

Code: 
=[Forms]![fReporting]![comLocation].[Column](1)

Dan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
257
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
254
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
447
caykamanj1966
caykamanj1966
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
268
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
107
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top