been working on opening a form from another form. (i had to read over that a couple times to make sure i got it right ha ha!).
form setup:
search button and criteria
(self explanatory)
subform
(shows results from the search criteria)
open ItemMaster cmd button
(this is supposed to open ItemMaster to the record i select in the subform)
i want to be able to have a subform with the results from a search (which i've already done). Then to be able to select one row within that subform and click on a command button to open a form, ItemMaster, that has more detailed information on the product.
success that i have had:
using the DoCmd.OpenForm command to open the form, but the criteria i put into the rest of the row opens to a random record within ItemMaster. I think the problem i'm having is referencing the correct record number.
Is there a way i can link two tables together with a query and use the field in one of those tables to open to the correct record in the itemMaster form?
if i need to be more clear, please let me know.
thanks!
tommy
form setup:
search button and criteria
(self explanatory)
subform
(shows results from the search criteria)
open ItemMaster cmd button
(this is supposed to open ItemMaster to the record i select in the subform)
i want to be able to have a subform with the results from a search (which i've already done). Then to be able to select one row within that subform and click on a command button to open a form, ItemMaster, that has more detailed information on the product.
success that i have had:
using the DoCmd.OpenForm command to open the form, but the criteria i put into the rest of the row opens to a random record within ItemMaster. I think the problem i'm having is referencing the correct record number.
Is there a way i can link two tables together with a query and use the field in one of those tables to open to the correct record in the itemMaster form?
if i need to be more clear, please let me know.
thanks!
tommy