Open Form Shows how to

Thank you Donald. Let me tell you what I am trying to do. I may be explaining it wrong. I have a DB that is home inventory. I have a product form that has the description of the item on it. On that form I want to put a button to open up the vendor information where I purchased it from. Right now I may be doing something wrong. If I put the button on the form (to open the vendor form) no matter what product I am on it opens to the same vendor.

In order to open to a specific Vendor, you need to ensure that the index key for that Vendor is accessible to the form, either in the recordset of the table or query.

So, as an example, if your product table contains the Vendor ID along with the product, you might have a button such as "OpenVendorBtn". In the on click event of that button, you might have code like:

Details

Private Sub OpenVendorBtn_Click()

     docmd.openform "VendorF",,,"VendorID=" & VendorID

End Sub
Copy

This would open the form named VendorF to the record with a matching VendorID

So do I add a combo box on the product table showing the vendorID? Then use that field to show on the product form and create a button?

Donald Thank you. I figured it out by accident. But I figured it out.

Donald never mind. I hit something and deleted the box. I know how to do it but dont know how to get what helped me. I think it was somewhere in using a wizard you choose 2 fields and combine them and it worked with that. Dont know what that is called or where I found it.

End of this thread. I am done. Figured out what I was looking to make it happen. It the Button wizard instead of combo box wizard. PROBLEM SOLVED

Lee, the Button Wizard will let you do that:

Add a button to your form
When the wizard opens, choose Form Operations
In the Actions list, choose Open Form and click Next
Choose the Form you want to open and click Next
Choose the option to Open the form and find specific data to display and click next
It will give you 2 list boxes, on the left, the fields in the form you added the button to
     In the right, the fields in the form you are opening
Select the field that matches in both (I.E. VendorID if that's your field) and Click Next
Choose either text or an icon on the next one and click next
Name your button and click finish

Thats how I solved it. Thank you for your patience and knowledge.

Happy to help. Sorry I didn't think of the wizard first... I don't usually use them...

I started coding online the "hard way", digging into other people's code and trying to bend it to my will, lol. I used the wizards at first when I started with Access but then once I learned VBA, it just feels more natural to me, so some times I have to step back and remember to look at the built in tools.

Glad you got what you needed. Don't hesitate to ask if you find yourself in need of further assistance :)

Thank you. Have a great evening or night.