Unexpected variable or procedure, not module

A

Anne

I worked with this database on my old computer without a problem, but on my
new computer I get a an error message for each on current event.
The expression On Current you entered as event property setting produced the
following error: Expected variable or procedure, not module.
The on current event is simple:

Private Sub Form_Current()
Me.Parent.linkfield2 = Me.DeliveryID
End Sub

What else should I be looking for?
The program works perfectly on the old computer. The reference libraries are
the same, the Office Version on both is 2003.
 
A

Anne

The references libararies are exactly the same and listed in the same order.
I debugged it on the new computer and found by trial and error, if I
exchanged periods for exclamation marks it works. Example:
Me.Parent!linkfield = Me!LotID from
Me.Parent.linkfield = Me.LotID

Why would that need to be changed? I don't really understand. Why on the
first part after parent and in the second part after Me?
 
A

Anne

My old laptop has SP3 (11.8231.8221) my new one SP3 (11.8169.8221)
It looks like the old laptop has a newer version. I don't see a hotfix on
the update website. I will go an run the automatic update.
 
A

Anne

I updated the new laptop and now both have SP3. Actually I had the wrong
version because I assume all office product had the same update. Access on
the old laptop is 11.8166.8221 and the new one is no 11.8204.8221.

Just to test the issue, I copied one more time the working database which
still had all the periods and not exclamation marks from the old laptop to
the new laptop, and the same error message appear as before.
What else could it be?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top