Displaying first record on form

[MadCat]

Hi again

Hopefully a simple question. I have a form that has a text entry box and a button. a value is input into the box and the button then clicked. the button brings up another form giving the user the relevant information. the problem is that when the form is closed the first form then jumps back to the first record as apposed to a new record which it should do. I've tried to write VB code to do this but i cannot seem to get it to work.

RESULT: I have it partially working, i added a goto new record command in the on activate event. this works when the 2nd form opens, but not when it gives the msgbox for no records.


Hopefully someone will be able to give me some idea of how to sort this.

Thanks In advance

 

[namliam]

Make the new form Dialog ( i think) this pauses the code untill your dialog form is closed. Continueing with the goto new record... Thus displaying a new one.

Regards

 

[MadCat]

Thanks for the reply

I may have a look into this method. i got round it by adding another goto New record command just after the msgbox is called. this seems to do the trick

Cheers