Need Help ASAP

[daniel]

Hello,

I'm trying to do a Dialog box that can be used for data entry. This form should have about 9 columns and over 75 rows, but I want the dialog box to show 10 rows at time and when those are filled, there would be a button that would create basically another dialog box for rows 11-20 and so on.

Then when all data is entered, I want the macro to sort these rows from oldest to newest date. After the sorting has been done, I need for the macro to send the first 75 rows and columns to another screen, which would require evey field to have it's own name. The records over 75, I need for the macro to write a text file or perhaps create an access table where they will be stored for future use.

In this dialog, I need for the macro to search for records 76-150 and send them to another screen at a later time.

Is this possible to do? Thanks for you help.

-daniel

[Bob Hansen]

This was already posted at http://www.mjtnet.com/forum/viewtopic.php?t=2078.

Suggest that you cancel this posting and continue at the above link.