Search results

Hi Pat, This is what I'm attempting to do. As I say I'm very new to VBA and to be honest relatively new to access in general. The design of the database may also be in question hence the reason I'm having difficulty doing something that access cant do..... easily.

Thanks ill have a look.

Hi. I tried rs.MoveNext but that only updates the first record.

VERY new to VBA and have spent hrs trying to work out why the Loop doesn't stop at the 'Loop Until rs.EOF' line. All records update fine but when it gets to the last record, the DoCMD line shown in red tries to get to the next record when there isn't one. I subsequently get a frozen form which I...