Zack Barresse
07-17-2006, 04:43 PM
Hey all, got one that's stumped me. I have a form in a database (eventually there will be many forms like this) that has criteria fields from a table that will show a report based on whatever the conditions specified in the form were (built on an SQL statement created at run-time via VBA). I've uploaded a sample DB which contains two tables, Lab_Samples (the data table) and tblOperators (a list of mathematical operators, I just created this table).
The idea of the form is for the user to specify which fields criteria he/she would like to filter the report on. I wanted to add some flexibility to the form, so instead of having each field be an exact match, I wanted to add, say,equals, does not equal, greater than, greater than or equal to, or less than, or less than or equal to. I figured I'd setup a table with this and have it as a combo box in front of each field I wanted with this ability.
I setup the VBA code already to what I think would be a working solution (don't know for sure) but after I add the combo boxes, name then and save the form, it's no longer useable. I think the form becomes corrupt. How, I'm not sure, but each time I try this the form is completely unusable afterwards. I have no idea what I'm doing. Once the objects are created on the form, the VBA code seems to compile just fine.
The form in the sample database is an original form before the adjustments I'm trying to make. If anybody has any idea how to make this better or how to get my idea to work, I'd really appreciate some pointers. Thanks for looking at it. :yes
The idea of the form is for the user to specify which fields criteria he/she would like to filter the report on. I wanted to add some flexibility to the form, so instead of having each field be an exact match, I wanted to add, say,equals, does not equal, greater than, greater than or equal to, or less than, or less than or equal to. I figured I'd setup a table with this and have it as a combo box in front of each field I wanted with this ability.
I setup the VBA code already to what I think would be a working solution (don't know for sure) but after I add the combo boxes, name then and save the form, it's no longer useable. I think the form becomes corrupt. How, I'm not sure, but each time I try this the form is completely unusable afterwards. I have no idea what I'm doing. Once the objects are created on the form, the VBA code seems to compile just fine.
The form in the sample database is an original form before the adjustments I'm trying to make. If anybody has any idea how to make this better or how to get my idea to work, I'd really appreciate some pointers. Thanks for looking at it. :yes