In Access Expert 8 Lesson 1 at 4:25, you add a command button to the ProductSubF to open the ProductF. When I attempt to replicate this using the command button wizard, Access does not display the fields for the ProductSubF.It does however, display all fields for the ProductF. As a result, I can't link the ProductSubF to the ProductF using the wizard. Interestingly, the record source is the same for both forms - Product T. Also interesting, when I tried going the opposite way - putting the button on the ProductF to open the related record on the ProductSubF, Access displayed all fields for both forms and allowed me to make the link. Any idea why Access would "see" all fields in both tables in one instance, but not in both? I ran into this same problem when trying to link the ProductVendorSubF to the VendorF. I was able to make the connection between the VendorProductSubF and the ProductF. Thanks in advance for any insights you can provide.

---

Reply from Richard Rost:

Were you working on ProductSubF while you still had ProductF open in design view? It's more reliable to CLOSE ProductF and then work on ProductSubF by itself. I'd have to recreate my steps from the video to tell you exactly what happened, but that's how I generally recommend you do it if you have problems. Could have just been a glitch too.