Kamis, 14 Juli 2011

Re: [MS_AccessPros] Subform Error Message

 

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]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar