Data entry

[Guest]

Hi all

I have a form I open via code with the acAdd argument. Rather than having
another button on my menu to open the form again displaying all records, is
it possible to add a command button to the data entry form to display all
existing records?

I know I can open the form with all records displayed and use the cmd goto
new record but the form is in continous mode and I don't want the existing
records to be displayed before the new record.

I think I may be able to achieve this somehow using subforms but I would
like to know if there is a simple way of achieving this?

Thanks in advance for any help.
Sue

 

[fredg]

Hi all

I have a form I open via code with the acAdd argument. Rather than having
another button on my menu to open the form again displaying all records, is
it possible to add a command button to the data entry form to display all
existing records?

I know I can open the form with all records displayed and use the cmd goto
new record but the form is in continous mode and I don't want the existing
records to be displayed before the new record.

I think I may be able to achieve this somehow using subforms but I would
like to know if there is a simple way of achieving this?

Thanks in advance for any help.
Sue

Add a command button to the continuous form's header or footer.
Code it's click event:

Me.DataEntry = False

 

[Guest]

Simple when you know how! Thanks, worked a treat...

Regards
Sue