I am being prompted to "Enter Parameter Value" when clicking on Cmd Button

[Chris Brooks]

I used the CmdButton Wizard and arrived at the following:

where condition: "[Vend_COMPANY]=" & "'" & [Vendor] & "'"

I am trying to Open a separate pop up form [VendorPop] based on the currently selected Company Name in my Sub-Form.

When I click on the Cmd Button, I am prompted to "Enter Parameter Value".

My Sub-Form is based on a Query that includes Data from Two Tables.

I have a Main Vendor Information form to Capture all of the Vendor Details; however, I am trying to open a quick Popup Form to do quick edits like adding an Email or Phone #.

I have NO HAIR LEFT. Please help.

[Stewart Ross]

Hi Chris. There is no problem that I can see with your link statement's construction. If you are being asked for a parameter value it's because Access cannot find one or other of the fields involved.

Check carefully the names of the fields/controls involved - is it possible that field [Vend_Company] in the recordsource of your pop-up form is actually [Vend Company], or [Vendor Company], for instance? Is the company name control on your subform actually called [Vendor]?

Hope you manage to track down the problem without losing your hair altogether!

-Stewart