Compile error

I am trying to modify the code in this article on staging data to suit my database needs. https://www.experts-exchange.com/A_6692.html When I run the code I get a compile error. The form is tempServices. Select a sample number, select a category then click Load Services - that's where the error comes up. I am uploading a data stripped version of the front and back end if someone would like to have a look at it.

I am also wondering how to modify the code to select all categories and then load ALL services?
Thanks!
NBDC-be.accdb
NBDCv203.accdb

Microsoft Access

Last Comment

esbyrt

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Bitsqueezer

1/4/2014

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

esbyrt

1/4/2014

ASKER

Hi Christian. Thanks for taking a look. I'm sure part of the problem is that I was trying to post as little as possible of my working database onto the internet for public access. I must have left out some tables. And yes, I did copy the code for the problem form from a demo database and change the field and form names to match my database. I guess I will have to go through and correct the errors you spotted before I can go further with it.
Thanks again.

Edit - had another look at my database - most of the problems you found were from a form I was mucking around with and had discarded but not deleted yet. My bad. I will clean this up and repost after.

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

Certified Expert Program

Credly Partnership

Udemy Partnership