'Disappearing' records in a subform after a requery

[eschaef2]

Hi everyone,

I am new to this forum, and would like to ask for some help with an anomaly that I am experiencing with a linked subform.

I have a few workers (employees) that are responsible for filling out paper work assessments within a fixed time period (28 days max). Each assessment has a unique ID number.

The paperwork can be in one of three states (open, review, closed)

Any employee can (and does) have more than one assessment at any given time.

I built a table of assessments, dates opened, 28 day limit date, and assessment status.

Now the dilema:
On frm_Info I use two combo boxes (cmb_Employee; cmb_Status) to link to sfrm_Assessments. When I first select an employee name and status, all the appropriate records are shown.

Mr. Smith has four open assessments; I change assessment three to 'Review', then press 'Apply' on the main form, and assessments 1 and 2 'Scroll Up' (dissappear from the sfrm), and the only visible record is assessment four. If I click on assessment four, then press 'PgUp' a few times, the other two assessment records scroll down into the sfrm, and I can see all three (recall that I changed assessment three to review).

My Request:
Is there a way to 'bookmark' or 'force' the sfrm to show the first record after 'Apply' was pressed AND the current record was number three in the subform?

Or might there be another way to perform this task with filter(s), or additional forms (instead of a subform?)

Thanks for reading, and best regards,
Eric Schaeffer (part time programmer at large)

 

[Pat Hartman]

Your Apply button is not necessary, nor is the requery. Access is automatically saving the current record of the subform as soon as focus moves back to the main form. To prove this to yourself, put message boxes in the BeforeUpdate event of the subform and in the click event of your Apply button. You'll see that the update of the subform is executed prior to the code in your click event.

 

[eschaef2]

Hi Pat,

Thanks for the advice... The requery was / is an attempt to 'update' the worload list for an employee after they change a few of the assessments' status.

At this time I have removed the 'Update' button, and state that the user must select a different status (closed, review), then re-select Open to see their current workload.

Thanks again for the reply,
Eric