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

Combo box within a form

P: 1
I have a combo box that list all the number of parts, I click on the bottom and select the numbers that I want to display on a report but the problem that I having is that the report is showing all the data.

this is my code


DoCmd.OpenReport "daily scheduling report", , , acPreview, , "[Cyl ASSY] = '" & Me![cyl Assy] & "'", acWindowNormal

I have a combo bottom and I have a preveiw report on the form this is the code for the prveiw report bottom

need help

JJ
Nov 3 '11 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 446
Jackie,
You have too many commas in the command. Try
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport "daily scheduling report",   acPreview, , "[Cyl ASSY] = '" & Me![cyl Assy] & "'"
S7
Nov 4 '11 #2

Post your reply

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