Search results

That fixed the problem. Thank you; much appreciated.

#1 has the query set at no parameters so all of the records are displayed. #2 raises a small form requesting data input and any records with a matching valve are returned.

I'm through for the day; this has consumed a lot of time and I'll look at again in the morning. Appreciate the time and thought all have offered. Thank you!

Renamed the form w/o spaces. New error message: Run-time error '3463': Data type mismatch in criteria expression. The ProductID is a text field. The field on both forms are Plain Text.

#1 is when there isn't a parameter request for the query. All of the records display. #2 is when there is a prompt in the query for a unique criterion (valve) raised after clicking the form. When a valid value is entered the unique record will display in the form.

Form opens correctly when clicked directly and 1) displays all of the data or, 2) if there is a request for a parameter, just the requested record.

Appreciate you finding the missing bracket.

Modified the statement to the following: DoCmd.OpenForm "[Product Transactions View Subform]", acNormal, , "ProductID=" & Me.ProductID The error message in Post #1 is raised. Removed the brackets ( [ ] ) to this statement: DoCmd.OpenForm "Product Transactions View Subform", acNormal, ...

This message - Run-time error '2101'... - is raised when double clicking a field on a form, to open another form. Full message: Run-time error '2102' The form name '[Product Transactions View Subform]' is misspelled or refers to a form that doesn't exist. The form exists, opens as a Display...

Fascinating dialogue. This capability breathes lots of new possibilities. Client usability question. With the ability to view a supplier's 'place orders' website page, could the data entered be trapped and written to the Access DB when page/form Submit button is clicked?

Really appreciate all of the feedback. Pat, after Galaxiom replied, I did the update you suggested. How have a Recorded Created Now() field for record ('er, User) monitoring and an editable Transaction Date() in place. All works well. Again, thanks to all who replied. Enjoy the Holidays!

Thanks for the assist!

Working on a new app with Access 365. This morning queries with Start / End parameters fail on the EndDate criteria. Have to ask for one additional day to have the dataset return the needed data. Example: Between [Forms]![Report Date Range]![BeginDate] And [Forms]![Report Date...

Zydeceltico, there's a lot of great advice in this thread. I've been through this scenario sooo many times. Twenty-five years with Access development, plus SQL for back-ends. Still dealing with 90-day wonders (IT guys) who create huge problems with their bias, especially, as seems to be your...

Consider: Unlike FIFO, Last in, First out (LIFO) increases the "value" of earlier items in stock, thus creating a "paper" profit via increased inventory value. Most bean counters are opposed to that concept as they have to come up with the cash to pay the taxes while the product remains on the...

Called back to work on some apps that are 20+ years old. Retired seven years ago but still in demand. Will it ever end?