Go to Previous Record

[BLW]

I have a form that is based on tblAssessments. At the top of the form it
lists the fields assessdate, worksite, and department. I have a subform
based on the same table that is linked to the main form by the department and
date; therefore it only lists the entries for that particular department on
that date.

There are several records each day for each department.

I want to create of "Previous" and "Next" button. When I use the built in
buttons it takes me record by record for each department; meaning I have to
go through all the entries for the current department before the form changes
to the next department. I have to click up to 20 times or more. Is there
anyway to make it jump to the next department?

Thanks for any help!

BLW

 

[Jeff Boyce]

That design strikes me as a bit unusual.

It is very rare to have both a main form and a sub-form based on the same
dataset (e.g., table). Usually this design is used to display one-to-many
relationships ("one" in the main form, "many" in the sub-form).

Is there a chance that your data structure needs further normalization?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[BLW]

Thanks - that's what I thought too, I was just hoping for another option.

BLW