ReQuery

[kronar30]

I have a form 'frmEnterTime'
which has a subform 'EmpTimebyDate'
whos record source is 'UpdateTimeQuerybyDate'
order by 'JBT_Date DESC'
UpdateTimeQuerybyDate SQL is 'SELECT * FROM JBT_EmpTime ORDER BY JBT_Date DESC , JB_JobBidNo;'

After User adds a record I run the requery
qrycall = ChangeQueryDef("UpdateTimeQuerybyDate", "select * from [JBT_EmpTime] where JB_JobBidNo = '" & hldJobNum & "' order by JBT_Date DESC")
[TimebyDate].Form.Requery

The subform displays the new record added as long as the new recs job number is the same as the records originally displayed in the subform.
However if the new record has a diferent job number then the subform does not seem to update still showing the original job number records.

I thought that the requery would change the query for the record source and display the new results??

Thanks

 

[dhookom]

The last update to the TimeByDate subform control sets the record source to "select * from [JBT_EmpTime] order by JBT_Date DESC, JB_JobBidNo" so it will display all records.

Duane
Hook'D on Access
MS Access MVP