When a new record is added in the Order Details subform, the "UnitPrice" field is first displayed with "0" (the default value for the [Order Details].UnitPrice field), and then immediately updates that value with the value contained in the [Products].UnitPrice field.
This has the desired result of copying the value in the [Products].UnitPrice field to the [Order Details].UnitPrice field.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I can't get a Before Update Event on a form to execute correctly in a function. The error I get is:
"The expression BeforeUpdate you entered as the event property setting produced the following error: The object doesn't contain the Automation Object 'AuditTrail' "
As part of my attempt to find out why, I opened up the mystical Northwind MDB, created an identical function, tried it out and it works fine.
I used the documenter to compare properties of the forms in my mdb versus the Northwind MDB and didn't see any big show stoppers there.
The only difference I can see is that in my mdb, On the Form properties, Event tab, Before Update line, I try to enter "AuditTrail()" and the system replaces what I type with "[AuditTrail]".
In the Northwind MDB it doesn't replace what I type and keeps it as "Audit Trail()".
Does anyone have an idea if the [ ] is causing the problem and if it is what property setting do I have to change or whatever to make it work?
Tom in a very hot Austin, Texas
Nothing is listed behind this tab. What do I need to do to load these samples (hopefully, without loading a security number - this caused great difficulty originally)? It seems that using the 2000 version will not the most beneficial.
Also, where can I find out what those little icons mean?
or I also have Access 2007 Bible in .PDF format (1400 pages) if anybody has the sample dbs or whatever else is on the included cd.
He has to type in the product number to get the set of colors specific to a shirt selection.
Another thing that happens, is when a new row is added to the subform, no matter what new shirt is selected, the previous selected product ID "sticks" and only the filtered colorselections from the first selection appear.
but then again I don't know Northwind that well,
How can I keep my records and upgrade it to the new 2010 version.??