Search results

Yes. Each inspection type has a different inspection method and therefore completely different fields

Thanks Bob. That got rid of the syntax error. How do I set up the code to open a specific form for each value in the listbox? Thanks

On my form I have a listbox "Insplist" generated by a query. The listbox shows the types of inspections available (there are 5 unique inspection types). When a value from the listbox is double clicked, I want it to open the corresponding inspection form. At this point I can only get one form...