By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,603 Members | 1,388 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,603 IT Pros & Developers. It's quick & easy.

Continuous Forms in 2007

P: 53
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



Expand|Select|Wrap|Line Numbers
  1. Me.Parent.Form.RecordSource = "SELECT VCMInpsectors.* FROM VCMInpsectors WHERE (INSPID = " & Me.INSPID & ")"
  2. Me.Parent.Form!frmVCMMatrix.Form.RecordSource = "SELECT VCMMatrix.* FROM VCMMatrix WHERE (INSPID = " & Me.INSPID & ")"
  3. Me.Parent.Form!frmVCMQuals.Form.RecordSource = "SELECT VCMQuals.* FROM VCMQuals WHERE (INSPID = " & Me.INSPID & ")"
Sep 19 '08 #1
Share this Question
Share on Google+
1 Reply

P: 53
Found the issue.

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

Sep 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.