2 Form questions

I have my master form to close after the submit button is clicked. What can
I do so that the next time the form is opened it opens to the next record
(i.e. if form 3 was submitted it opens to form 4)

Secondly, I have a combo box that people can also type in for a record. If
they add "Joe Smith" for example on record 3 is there a way to make that
entry come up in the combo box on record 4?

THANKS!

1) Store the record number in a public variable on the "on close" event.
Then when the record is opened move to the correct record

--

Kind Regards
Damiaan
e: info at dampee.be
w: http://www.dampee.be


"accessnewbie" wrote in message
...
I have my master form to close after the submit button is clicked. What
can
I do so that the next time the form is opened it opens to the next record
(i.e. if form 3 was submitted it opens to form 4)

Secondly, I have a combo box that people can also type in for a record.
If
they add "Joe Smith" for example on record 3 is there a way to make that
entry come up in the combo box on record 4?

THANKS!

Thanks!

Do you have any idea on the answer to my second question about typing a new
entry into the combo box and then that entry reappearing.

Secondly - and forgive my ignorance - what is 'public variance' and how do I
do that?

"Damiaan" wrote:

1) Store the record number in a public variable on the "on close" event.
Then when the record is opened move to the correct record

--

Kind Regards
Damiaan
e: info at dampee.be
w: http://www.dampee.be


"accessnewbie" wrote in message
...
I have my master form to close after the submit button is clicked. What
can
I do so that the next time the form is opened it opens to the next record
(i.e. if form 3 was submitted it opens to form 4)

Secondly, I have a combo box that people can also type in for a record.
If
they add "Joe Smith" for example on record 3 is there a way to make that
entry come up in the combo box on record 4?

THANKS!