Okey heres the deal,
We've got a form based on a table (frmFeatSelection based on tblFeats), and another form based on a query that determines it's results by whatever is selected as "YES" in tblFeats (frmSelectedFeats, based on qselSelectedFeats). Now the two previously mentioned forms are set up as subforms in frmFeats that simply displays the data.
Now for the problem.....
When we access the frmFeatSelection and change a couple records to Yes, then click on a button to update all forms it works. The kicker is that it only displays the the "YES" record if the first record has been clicked to yes. How can I make it so that I can select something other then the first record and have it update.
We've got a form based on a table (frmFeatSelection based on tblFeats), and another form based on a query that determines it's results by whatever is selected as "YES" in tblFeats (frmSelectedFeats, based on qselSelectedFeats). Now the two previously mentioned forms are set up as subforms in frmFeats that simply displays the data.
Now for the problem.....
When we access the frmFeatSelection and change a couple records to Yes, then click on a button to update all forms it works. The kicker is that it only displays the the "YES" record if the first record has been clicked to yes. How can I make it so that I can select something other then the first record and have it update.
