want cursor to go to new record in subform

[mitchem1]

I have a form that is used to search for a project. When the correct project is found, the user double clicks it and a project info form is opened where the user can enter comments (subform). I have it set up so that if a comment has been entered previously, it cannot be edited. This means I would like the cursor to go to a new record, but currently it goes to the record that cannot be edited. Greatly appreciate it if someone can point me in the right direction. Thank you.

 

[Mile-O]

Would something like my comment example on this thread be of any help?

 

[mitchem1]

Sorry, cannot download the .zip file.

 

[Mile-O]

I've emailed it to you.

 

[Mile-O]

And got it sent back immediately...

 

[arvindn]

Use

subform-name.form.recordset.movelast
subform-name.form.recordset.movenext

when u want to go to a new record.
Hope that helps.