Deb,
Have you checked the Before_Update event of the form to see what is there? Whatever is there sounds like that is what is causing the problem not the RecordSource.
Thanks,
Gina Whipp
2010 - 2011 Microsoft MVP (Access)
www.regina-whipp.com
From: Deb
Sent: Thursday, July 14, 2011 5:07 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Subform Error Message
Hi all,
I have a subform called parts_individual_subform, located on a tab on the
parts_individual main form.
When I try to test it and enter data into it I get the following error
message:
"The expression Before Update you entered as the event property setting
produced the following error: The object doesn't contain the Automation
object 'parts_individual.'.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procdure].
*There may have been an error evaluating the function, event, or macro."
Once this happens I cannot close the form, try to edit it, or do anything
without the message popping up again. The only way to do anything is to
close Access using the X button.
Here is my record source for the sub form, obtained by clicking in the upper
left "box" in the subform.
Sub Form Record Source =
SELECT parts_individual.ID, parts_individual.Date,
parts_individual.[Supplier ID], parts_individual.Supplier,
parts_individual.Price, parts_individual.[Include Tax],
parts_individual.Tax, parts_individual.[Ext Tax Price],
parts_individual.Per, parts_individual.[#Pack], parts_individual.Quantity,
parts_individual.[Shipping Cost], parts_individual.[Unit Price] FROM
parts_individual;
These all point to my parts_individual table.
Also on this tab are controls that are located above the subform that point
to fields in my Inventory_Parts table. They are not located in a subform,
but are simply placed on the first tab.
There are 2 other tabs, both contain other subforms.
Any help would be greatly appreciated, I have no clue what I did wrong - big
newbie!!
Thanks,
Deb
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Kamis, 14 Juli 2011
Re: [MS_AccessPros] Subform Error Message
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar