469,150 Members | 1,975 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,150 developers. It's quick & easy.

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

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.
Attached Images
File Type: jpg ScreenShot.jpg (61.5 KB, 232 views)
Sep 1 '10 #1
1 1576
Stewart Ross
2,545 Expert Mod 2GB
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
Sep 12 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.