Continuous Forms in 2007

[Echidna]

Hi Guys,

I have a bit of a perplexing problem with an ADP file which has been migrated from 2003 to 2007.

It was working perfectly well in Runtime until we upgraded everyone to 2007...

I have a Continuous form which has the Recordsource set within VBA.
The Form shows the data for a split second and then the Data disappears from the screen.

If I do a Manual Filter, the Filtered Data returns correctly.

also when I click on the Record it filters three other forms containing data relevant to the Inspectors in the main Continuous form.
it interrupts advising that the object the event is referring to is Closed or does not Exist.

any ideas why 2007 is acting like this?

any help would be greatly appreciated

Cheers


Leon

Me.Parent.Form.RecordSource = "SELECT VCMInpsectors.* FROM VCMInpsectors WHERE (INSPID = " & Me.INSPID & ")"
Me.Parent.Form!frmVCMMatrix.Form.RecordSource = "SELECT VCMMatrix.* FROM VCMMatrix WHERE (INSPID = " & Me.INSPID & ")"
Me.Parent.Form!frmVCMQuals.Form.RecordSource = "SELECT VCMQuals.* FROM VCMQuals WHERE (INSPID = " & Me.INSPID & ")"

[Echidna]

Found the issue.

Filter on load was set to yes,
for some starnge reason this was causing the Form to filter on Nothing.

Leon