open form/subform to last record

[Guest]

This question may seem silly but here it goes. I know I can base a form off
a query to open to the last record. Question is, we basically use our forms
to enter data, so if it's based off a query would you still be able to enter
a new record on the subform?

I have a wage form and wage subform. The main form has the Employee ID and
name and is pulled from the tblEmployees. The subform has all wage
information and history for that employee; it has the dates the changes took
place also. It pulls from the tblWage. Currently when you open the form, it
will pull up the very first record for that employee in the subform. I would
like it to pull the last wage record in the subform instead of the first to
avoid confusion among people. I've tried to do a Macro but I always get that
subform Wage is not loaded when I put it in the form.

 

[Rick Brandt]

This question may seem silly but here it goes. I know I can base a
form off a query to open to the last record. Question is, we
basically use our forms to enter data, so if it's based off a query
would you still be able to enter a new record on the subform?

I have a wage form and wage subform. The main form has the Employee
ID and name and is pulled from the tblEmployees. The subform has all
wage information and history for that employee; it has the dates the
changes took place also. It pulls from the tblWage. Currently when
you open the form, it will pull up the very first record for that
employee in the subform. I would like it to pull the last wage
record in the subform instead of the first to avoid confusion among
people. I've tried to do a Macro but I always get that subform Wage
is not loaded when I put it in the form.

You could sort the subform so the newest records are at the top. And yes, a
simple query based on each table that merely imposes a sort order or a filter
will still be editable (including adding new records).