Subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form with subform. When I go to a new main form I want the
cursor to go to last record in subform. Any help on how to do this would be
appreciated.

Thanks,
Floyd
 
UNTESTED --
Create a macro that is On Open property. First step to set focus to
subform. Next GoTo Record, Last.
 
Not very familiar with Acess. Let me restate the problem.
I have a different main form for each customer, then I have a subform for
all the individual orders for that customer. When I open each main form I
would like to go to last record of that particular subform. I am using a
switchboard to open the main form, then I use selector at bottom to page thru
different cutomers. Want to put cursor on last record of each subform as it
opens. Just don't know how to do.
Thanks if you can help.
Floyd
 
Use the same query as record source for the main form and subform. Open the
query in design view and set the SORT for the field used to identify
Customers in the main form to Ascend. Set the SORT for the field used to
identify Orders in the subform to Descend. Make sure the Customer field is
to the left of Orders field in the design view.
 
Back
Top