Hi,
I cannot seem to get docmd.findrecord to work on a sub form.
On my main form users can enter a record id in a text field, which then looks the record up on the sub form. The recordset for the subform is based on another field on the main form so that only records for the selected week are shown within the sub form. However i do not want to requery the sub form so that it only shows the required record, i need to keep them all showing, but have the specified one selected.
Any ideas,
Thanks in advance
MartinF
I cannot seem to get docmd.findrecord to work on a sub form.
On my main form users can enter a record id in a text field, which then looks the record up on the sub form. The recordset for the subform is based on another field on the main form so that only records for the selected week are shown within the sub form. However i do not want to requery the sub form so that it only shows the required record, i need to keep them all showing, but have the specified one selected.
Any ideas,
Thanks in advance
MartinF