Hello everyone.
Today I am working on creating a Main form with tab controls and subforms. I have a search feature using an option group to select one of three fields to search in, and a text box to type the search criteria. The list box uses SQL to generate matching records from one table based on the search criteria.
I would like the user to click on a row in the listbox to select it, store a value from that row, and then click on a button that uses that value to populate the subform with additional data from a couple of tables and a query or two.
The subform only has six controls, atm, an image, part number, description, location, category and quantity. the image will be an OLE object; the quantity is a calculated field from a query, and the rest are fields from tables but put together using queries.
Ideas?
I am currently thinking that creating another query to bring all this together, and use a parameter for the correct record's information.
Thanks.
Today I am working on creating a Main form with tab controls and subforms. I have a search feature using an option group to select one of three fields to search in, and a text box to type the search criteria. The list box uses SQL to generate matching records from one table based on the search criteria.
I would like the user to click on a row in the listbox to select it, store a value from that row, and then click on a button that uses that value to populate the subform with additional data from a couple of tables and a query or two.
The subform only has six controls, atm, an image, part number, description, location, category and quantity. the image will be an OLE object; the quantity is a calculated field from a query, and the rest are fields from tables but put together using queries.
Ideas?
I am currently thinking that creating another query to bring all this together, and use a parameter for the correct record's information.
Thanks.