472,123 Members | 1,422 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,123 software developers and data experts.

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, 237 views)
Sep 1 '10 #1
1 1673
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!

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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.