I think I pinpointed the problem by looking at the table. The DirectorID is 0 everywhere.

The Director Form has both CompanyID and DirectorID fields but set to Visible No.

The individual subforms also have CompanyID and Director ID fields (otherwise I get an Automation Object error because there is no CompanyID)

But this is Klingon to me...

Rewatched the techhelp video. The only foreign key needed was the customer ID.

In my case I should only need the DirectorID. I deleted the records from MiscDirectorT and removed CompanyID in designview. Also on subforms I deleted the DirectorID and CompanyID as Richard did not insert them in video.

With blank MiscDirectorT, I tried to add a new record in the form, and got this error (attached)

OK. Fixed It. The Link Master/Child Fields were set to CompanyID (no idea how that happened). Changed them to DirectorID and now everything is working.

Doesn't it feel good to figure it out on your own? :)

Yes! :)

Hi Jean-Pierre
I love your notepad to the side with the code for the MiscBtn.
Is this something you created in access to show the code for each button that has the focus?
Might be a great Tech Help video?

Hi Michelle!

You know how a lot of people use the yellow post-it notes, write something on it, and then stick it on the edge of their PC monitors? Could be notes about anything, a to-do list, phone numbers, grocery shopping, appointment in the afternoon etc etc. It ends up being very messy, and my staff start panicking when one of their notes falls off the monitor or goes missing.

So I decided to create an electronic notepad stored on the database. I used Excel to make it look nice, copy-pasted into an Access single form and added 3 fields. My staff can use this instead of post-it notes and use it however they want to help them do their work. There's a button on the main menu that opens it.

I use it to list my different projects, and to records VBA codes in case I need to use them again, and when I'm done with something I just delete the record on the form. An added bonus is that on property setting popup is yes, so stays on my screen even if I minimise Access.

Your idea of a TechHelp video sounds very cool! But I have only started learning about Access since a month, so a bit too early for me :)

I love it, well done!

Very cool.