Review updated database attached to determine cause of error described in previous post

[Jerry Call]

Pay attention only to frmOpening and frmSodaCatalogue. The latter is where the problems lie.
The other catalogue forms are incomplete (although they work, unlike
my present frmSodaCatalogue). In the finished version frmOpening will be the
splash screen, and users will select Soda Tally Catalogue from there. But you
can also call frmSodaCatalogue directly. Either way, both have the crippling problem.

The two procedures that seem to be causing the trouble are FulUnitCost_AfterUpdate() and
ItemName_BeforeUpdate.



I'm not sure I've managed to get my ZIP file included here. The methods of doing this
are still awkward for me. There's an ikon with my file name on it, so let's hope that's
what you're looking for.

[June7]

There is no file attached. Should this have been continued in existing thread?

[Jerry Call]

I have the right file located in my computer directory. I can click on it and successfully drag it
to the proper place. But when I let go of the mouse the image disappears!
You'd think it would be a simple Copy/Paste operation, but it ain't
working for me! I can Copy it within my own computer, but how to
get it to Paste when the image is in your spot?

[June7]

Don't know what to say, attaching files here is simple enough for me. Haven't you already done this in other thread?

Browse instead of drag.

[Jerry Call]

It is very weird, indeed, because I succeeded earlier on. The main problem then
was figuring out how to make the zip. Now it's getting the zip to you.

I'm not sure how to do the Browse method. However, I could easily send it to
you in an email if I knew an address.

Aha! I tried the Browse technique, and I think it worked! Check it out.

[June7]

No, there is nothing attached. Click "How to Attach Files" button at top of page.

[Jerry Call]

I saw it happen. Now down to business. Check out frmSodaCatalogue mainly. I already told you the
two items that took it down (but earlier ran perfectly).

I see also that the MISSING frmSodaCatalogue also appears in the other catalogue forms.
Seems very mysterious.

If something has been mistakenly deleted, how can it keep hanging around to mess me up now?
frmSodaCatalogue has already been deleted numerous times, and replaced by cloning
frmCoffeeCatalogue.

[June7]

I don't see "MISSING" anywhere.

Issue is due to mis-declaration of AfterUpdate event. AfterUpdate does not have a Cancel As Integer argument, BeforeUpdate does.

Private Sub ItemName_AfterUpdate(Cancel As Integer)

should be

Private Sub ItemName_AfterUpdate()

Then you have

Option Compare Database
Option Explicit

located within FullUnitCost_AfterUpdate()

Those lines can only be in a module header.

[Jerry Call]

Thank heaven for fresh eyes! Everything working fine now. Appreciate your patience. However, you say
you can't see any "MISSING frmSodaCatalogue." Well, I'm looking right at it this very moment in
the Object Dependencies section of SodaCatalogue. Under Tables there are two items:
"MISSING frmSodaCatalogue" and "tblSoda." The latter, of course, is fine. And it would
seem that the MISSING item can be overlooked, because the form came right up
running smoothly when I opened it.

So chalk up another victory for the forum gang. Twenty smilies for y'all.

[June7]

Learned something new. I've never given any attention to Object Dependencies pane. So now I see what you were talking about. Review https://answers.microsoft.com/en-us/...0-b3f2a848bd27