I'm using the FindRecord command in VBA (Docmd.Findrecord)to move to a specific record on a form which has a query to provide its data. Although the code gets me to the right record number (according to the record selector), the data displayed on screen remains the first record in the recordset. If I move the form onto the next record and move it back again, (using the record selector), the correct record is displayed. I've tried putting in a line of code containing the Refresh action but this doesn't change anything. Although I could program the VBA to 'MoveNext' and then 'Move Previous', it's messy. Does anyone know why this is happening and how I can correct it. Thanks.
Steve House
shouse@icaew.co.uk
Steve House
shouse@icaew.co.uk
