Hello. 
I'm fairly new at Access, so apologies beforehand if this sounds confusing!
I originally set up a query that searches for classes in a directory based on four parameters: the location, grade level, semester, and year. However, I didn't want the query to pull up four separate pop-ups, so I designed a separate dialog box from a blank form that would prompt the user for all four parameter values (via combo boxes) in the same window.
I programmed an 'OK' button that runs the query, which takes the values from whatever's selected in the form. It pulls up the classes I want, BUT it also overwrites an entry! I ONLY want the query form to SEARCH and pull up classes without editing the data.
I've tried editing the property of individual combo boxes, setting "Allow Edit" to 'NO', but that just prevents me from making any selections at all in the form view.
Any suggestions and tips would be highly appreciated!
And I posted this question under 'Forms' rather than 'Query' because when I run the query alone, it always pulls up the correct fields without overwriting data in the table, even when I leave some of the parameters blank. This led me to believe that something was probably wrong with the form. But please let me know if this is not the case!
I'm fairly new at Access, so apologies beforehand if this sounds confusing!I originally set up a query that searches for classes in a directory based on four parameters: the location, grade level, semester, and year. However, I didn't want the query to pull up four separate pop-ups, so I designed a separate dialog box from a blank form that would prompt the user for all four parameter values (via combo boxes) in the same window.
I programmed an 'OK' button that runs the query, which takes the values from whatever's selected in the form. It pulls up the classes I want, BUT it also overwrites an entry! I ONLY want the query form to SEARCH and pull up classes without editing the data.
I've tried editing the property of individual combo boxes, setting "Allow Edit" to 'NO', but that just prevents me from making any selections at all in the form view.
Any suggestions and tips would be highly appreciated!
And I posted this question under 'Forms' rather than 'Query' because when I run the query alone, it always pulls up the correct fields without overwriting data in the table, even when I leave some of the parameters blank. This led me to believe that something was probably wrong with the form. But please let me know if this is not the case!
