Parameter Value message box error

[streub]

I am using a form with an unbound textbox to search a table (Price List) for a specific product number (PvNum). The search process is initiated with a button that opens a subform with fields populated with data from that record. I am receiving a message box asking for a parameter value that if populated with the product number activates the subform with the associated data for that product number.



I have investigated what I can to find the cause but have not been able to locate what is triggering the error.

I have an identical search form and subform for another value that functions without an error.

I want to attach the file for inspection but unsure as to how. The form name is "Product Variant Search"

Hopefully someone can shed some light on my challenge.

Thank you

Steven

[CJ_London]

I want to attach the file for inspection but unsure as to how.

click on the 'go advanced' button at the bottom of the quick reply section, scroll down and select 'manage attachments'

The cause of your problem is either a form the query references is not open or you have spelt or referenced it incorrectly (in the query designer you can use the expression builder to navigate to the required control)

[streub]

I have attempted to download the file three times but nothing.

I do not recall making an actual query for either search forms. Are there such things as hidden queries?

Steven

[CJ_London]

Are there such things as hidden queries?

Not as such, only ones created in VBA. You can also hide a query or any object by right clicking on it and selecting hide

The search process is initiated with a button that opens a subform

look at the recordsource for this subform

I have attempted to download the file three times but nothing.

I think you mean upload, not download.

1. Go Advanced
2. Manage Attachments
3. Add Files- browse and select
4. once the path is displayed, click upload

[streub]

The recordsource for the subform is correct and the field name (PvNum) is spelled correctly.

Based upon your example of uploading it appears only the JPG designation is compatible. I was hoping I could send the complete Access file.

Thank you

Steven

[June7]

Yes, Access files can be attached (as well as Excel and others). Will probably have to zip the file. 2MB zip allowed. Use Windows Compression.

[streub]

Nice!!!

Thank you

Steven

[Micron]

try this for attaching files
https://www.accessforums.net/showthread.php?t=70301

If your field is on a subform, likely the subform reference isn't correct. You can usually determine this by opening the subform directly (as long as it doesn't rely on some other object that isn't open). If the subform opens without prompting, the issue is usually a reference to the subform that's made from the main form, regardless if that reference is something on the form or in the query that's behind it.

referencing CONTROLS on subform:
[Forms]![Main form name]![subform control name].[Form]![control name on subform]
NOTE: subformControlName may not be the same name as the subform itself

[streub]

Thank you for the reply.

The field (unbound textbox) is on the primary form. I did reference the control as you have explained but did not have any success; however, I will try it again exactly as you have suggested.

Steven

[streub]

Regardless of what I try I cannot get the file to upload.

You can access the file at a OneDrive account

Logon: troutwater
Password: One1253$

[June7]

Don't we need a URL? I tried that logon and it is ignored, just opens my own account.

Why does forum upload fail? The instructions provided are quite explicit.

[CJ_London]

you have compacted the db and zipped it?

[streub]

Cleaned, compacted and zipped.

[streub]

https://onedrive.live.com/?auth=1&id...99B9B88313907C

[streub]

https://onedrive.live.com/?auth=1&id...99B9B88313907C

It is not your instructions. I have done it in the past but with JPG files. It has to this damned laptop.