| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 21782 | 2002-07-03 23:52:00 | Access 97 database | Steve (838) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 59615 | 2002-07-03 23:52:00 | I have a main form with subforms. The main form is "customer", and the subform is "visit". When I select the customer, I'd like the "visit" subform to display the last record. I have written a macro to do it, but where should I attach it? (sub)Form_OnLoad () doesn't work. Cheers, Access experts, Steve |
Steve (838) | ||
| 59616 | 2002-07-04 05:49:00 | Make the source for the subform a query that selects the visit records. Have the query sort the records in decending date order and the first record, should be the last visit. When the subform opens, the first record from the query should be displayed. | wuppo (41) | ||
| 1 | |||||