Modifying record from a search result

[DanEaton]

I have set up a search form that is based on a query. It prompts the user for a product to search and displays all of the catalogs that contain at least that product (as there can be many). There is a button on this form called cmdModifyCatalog. This button, when clicked, activates the visible property of another button called cmdEdit which is located beside every search result record (the form is continuous). I want this edit button to open up my Catalog Entry form (frmCatalogDataEntry) and go to the record that the button is beside. In other words, if someone wants to modify or delete a catalog they will go to this search form with the product in mind (or vendor, there is a seperate vendor search form) and select the product that they wish to search, then modify the record when they find it. Once they are in the data entry form, anything can be done for editing. So my big problem is simply getting the data entry form to open up to the record that the user selects. Any ideas? Dan Eaton
deaton@caemachinery.com

 

[RiverGuy]

Hmm, interesting. I could tell you exactly how to do this if you were using VB forms, but in Access, makes it a little more difficult.

 

[DanEaton]

Anyone else??? I doubt if the solution is that hard? Someone out there must have tackled this before. Dan Eaton
deaton@caemachinery.com