Competent Performer
Windows 7 
Access 2007
Need Help To Fix The Following, Dont know where am making a mistake that when I run it, it asks Enter Parameter Value ?
Which is the company name and is already selected.
DoCmd.OpenReport "SalesWithNICrpt", acViewPreview, , "[CompanyName]=""" & [SleDescrip] & """"
DoCmd.Close acForm, "Dialog General Sales"
VIP
Windows 10 Access 2010 32bit
CompanyName is a text field that has full company name and not a company ID?
SleDescrip is a textbox with company name?
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 Access 2007
SleDescrip is a textbox with company name? YES (It is not a company ID)
SleDescrip is a textbox with company name? YES
VIP
Windows 10 Access 2007
Show a picture of the parameter request.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Competent Performer
Windows 7 Access 2007
Sample DB Attached
Sample.zip
VIP
Windows 10 Access 2010 32bit
Cause of issue is misspelled field in Company table: ComapnyName should be CompanyName
Should not save both CoID and CompanyName in Sales, only CoID. Use CoID to filter report.
DoCmd.OpenReport "SalesWithNICrpt", acViewPreview, , "[CoID]=" & [Text13]
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote