Search results

No, I believe the relationship between these tables is set up correctly. Initially, I was going to just add the lesson fields to the PlanProgramDetail table but not every recno_plnprgmdtl is also a lesson - only some are associated with lessons. I elected to make Lessons a table unto itself to...

I checked on the Source Object and the Link Child Fields and Link Master Fields of the subform. They still contain the correct information after I added more tables to the query of the subform (thus changing the subform's RecordSource). The strange thing is, the subform does display the...

Hi Pat, Your posts on this problem are very helpful as I am experiencing a similar problem with my cascading combo boxes. However, I think this fix creates another problem for me. Please refer to my post located at: http://www.access-programmers.co.uk/forums/showthread.php?t=101001 There is...

Well, I may have the terminology incorrect. Hopefully you'll be able to tell from this description of what I did - in the design view of the subform I went into the form's RecordSource and clicked on the ... button which took me into the Query Builder. I added the Lessons table to the...

Yes, the RecordSource of the subform is updateable. I am trying to build the subform on top of the tables themselves, not the queries.

Hi all, I am experiencing difficulties with a subform in a database I am designing for a dance group. First, a little background about the database. There are 2 main parts: a) a library of CD information and dance information as well as which dances can be done to which songs b) a tool to...