error when trying to open a page

[Bkndbrown]

I am trying to open a report from a form with the current record that is open on the form. The report is called NEOFormR and the common ID is personalID.



I am using the following code linked to a button

DoCmd.OpenReport "NeoFormR", acpreview , , "[PersonalID]=" & [PersonalID


Then when I try and run it I get the following error.

The expression on click you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communicating with the OLE server or Active X Control

I have tried changing my code to the text string form
DoCmd.OpenReport "NeoFormR", acpreview , , "[PersonalID]='" & [PersonalID & "'"

Also I tried running this with a simple macro and it would open the report but not to the correct record.

[ssanfu]

Is the missing closing bracket a typo?

DoCmd.OpenReport "NeoFormR", acpreview , , "[PersonalID]=" & [PersonalID]

[Bkndbrown]

Yes it is. I have the closing bracket

[ssanfu]

So it sounds like you are headed down the corruption path.

I had an Access 2000 dB that gave me an error something like "Lost connection to the dB", but both the FE & BE were on the same computer.
See this thread (post #2) on how I fixed my dB: https://www.accessforums.net/access/...ect-41760.html


Make a couple of backups BEFORE you start........