Web Development

Ask something
Discussion Locked

get previous record on form Access2000

0 helpful
5 replies

by phingers 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can anyone tell me the code to get the recordset from the previous recode on a Form and pass one of the fields to another field in the next record?

i.e. I want to use [finish_time] on the previous record as the default [start_time] on the next record.

5 replies

by phingers

I have looked at Q210236 already. I need it to work for all records on the form, not just new ones. I did, however manage to get your second suggestion working - it means the user must select the previous [finish_time] from the combo box, and I needed help from Q219273 to get it to work on my form as it's based on a parameter query

Thanks for your help

This discussion is closed to new replies.