On Click Event and Recordsource ???
Posted on 2008-06-18
I currently have a main form named "JOBMGMT" which includes 2 subforms. The subform at the top is called "JOBS" and teh subform below it is called "ISSUES". These 2 subforms are tied together by the field "MAGSO" which acts as my secondary key. Both subforms are also tied to their relative table, which holds all the information for each. I am trying to make it to where when I click on a certain row within my subform "JOBS", the subform below ("ISSUES") will query itself and return all the fields which contain the same MAGSO that was highlighted (clicked on) above in the JOBS subform.
Here is what I currently have done in order to get this to work...
I set up my On Click event for the top subform ("JOBS").... It reads as follows - forms("JOBMGMT").controls("ISSUES").requery
I then set up my recordsource for teh bottom subform.
I clicked on the bottom subform and on the form within the data tab i clicked on the button with 3 dots. The wizard tehn asked me to choose a table to query so I chose the JOBS table that the subform is linked to. I chose all the fields and below the common field (MAGSO) in the criteria field i used the wizard to create the following: [Forms]![JOBMGMT]![JOBS].[Form]![MAGSO]
Can anyone help me?? What am i doing wrong?