THANK YOU! I needed a query open for the "OK" button and a report for the "Open Report" (cannot figure out the report still) button so i did some digging and figured out that everything i needed for the query you already provided me! I created a listbox with user defined values instead of ones from the form, and then went into the query i was using when i clicked the "Ok" button and i set the property type criteria to match the main forms user defined listbox. The query works like a charm now, but i cannot seem to get the report to work. The report just like the query need to know what parameter is set in the list box (I tried the above code and got an error that said "There are currently no printers installed on this computer"??). Here is the code that produced the printer error:
Code:
DoCmd.OpenReport "tblProperty", , , "PropertyType = '" & Me.List13 & "'"
I hadn't mentioned it before since i figured it out for the query, but there is also a min price ("Text3") and a max price ("Text6") text box in the main form as well as the user defined list box (with the 3 options) which also needs to be a parameter for the report titled "frmProperty". I cannot figure out how to add them into the code above, or to even use a macro or something of that nature to get it to open with the correct parameters.
I also need the main form ("frmType") to get opened again when i close the report ("frmProperty"), not sure at all how i would go about this.