Cancelled Previous....

[jamesWP]

Hi there, I quickly made a database, and for some reason, can't get past this 'cancelled' error, to get it to occur, open the Companies form, click orders and then it pops up.

By deleting all of the data in my tables, I can get to a state where I can once again enter data, but after closing the orders subform and opening it again, once again I have the dreaded error.

If anyone has any ideas of why this may be happening, feel free to share them

Thanks alot,
James Prince

Edit,

Here's my table structure:

CompanyID PK Autonumber - Relationship
Name
Address1
Address2
Town
PostalalCode
TelephoneNumber
FaxNumber

OrderID PK Autonumber - Relationship
CompanyID - Relationship
WeekNumber
Price
PriceWithVAT

MPL Autonumber
OrderID - Relationship
PartNumber
Size
PriceEach
PricePer100
Quantity

Basically I used the forms wizard to create a linked sub form, and when moving to a new order thats when it errors I think.

 

[yellow]

Your filter has the wrong syntax in Private Sub FilterChildForm(). Change it to:

Forms![Orders].Filter = "[CompanyID] = '" & Me![CompanyID] & "'"

and your error will disappear.