var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Filter By Form Report (combobox issue)
I found the filter by form VB code here:
ACC2000: How to Filter a Report Using a Form's Filter
when I filter using a textbox value it works fine, builds a report. but when i use a combobox, it will prompt me to return the value's ID number, i want this to be automatically inputted.
i have a combo box field called asset type (laptops, desktop, Server.....)
if i choose laptop, it will return "laptop" for the filter, but the report needs the AssettypeID (which is an integer)
do i need to build some code that will return the Integer ID if a combo box is being used for the filter?
Filter By Form Report (combobox issue)
Take a look at the Combo-box usage and how to extract column value other than the bound column:
LEARN MS-ACCESS TIPS AND TRICKS Blog Archive Combo-Box Column Values
(Learn MS-Access Tips & Tricks)
Learn Advanced MS-Access Programming with sample VBA Code.
All responses are based on Access 2003/2007
What is the bound column?
Originally Posted by mike.burns7
Sounds like it needs to be the column index for the field AssettypeID in the combo box's row source.
i attached a screen shot of my combo box's properties.