I have two different forms that save to one table. I realize this is not the best way to handle a situation but it is what the client wants. I want to be able to enter data in the first form, click a button that will then take me to the 2nd form with focus on the same record I was in on the first form.
If I use current record on the init for the 2nd form it brings me to the last record that form was on and not the current record that I just entered on the first form. Using the onpush event of the first form I open the second form but am unable to determine which command I need to bring me to the same record that I am currently in. If I save the record from my first form prior to opening the 2nd form and use new record of course I will get the next record available and not the one just saved.
The main reason for two different forms is because the client wants them on separate pages. I have tried using a subform but this puts it all on one page causing the client to scroll and they refuse that. I have tried a page break but it still shows as one page, maybe that is just for printing purposes?
Here is the bottom line of the end result I need:
Open main data entry form: record 1
Enter client data from lookup, enter auto data from lookup (both allowing changes and additions to records) After the last entry on that page is entered I need to go to the second form (or a 2nd screen page, however else possible) and begin entering the parts information for that invoice. This of course needs to be the same record.
I prefer to save the information from page 1 before closing it and going to page 2. So if on the onpush of a button I set it to: save record, open form2, select record # just saved, allow data to be entered on this form ... which new action should I be selecting to focus on the last record saved from the previous form, and do I use 'change record' as my action once I have the appropriate focus?
Thanks. Any suggestions will be greatly appreciated. Also, the customer does NOT want tabbed forms. These two forms need to be separate or at least appear to be on separate screens. He only wants one screen to appear at a time so I will be closing each form upon saving and prior to opening the new form.
Cheryl
If I use current record on the init for the 2nd form it brings me to the last record that form was on and not the current record that I just entered on the first form. Using the onpush event of the first form I open the second form but am unable to determine which command I need to bring me to the same record that I am currently in. If I save the record from my first form prior to opening the 2nd form and use new record of course I will get the next record available and not the one just saved.
The main reason for two different forms is because the client wants them on separate pages. I have tried using a subform but this puts it all on one page causing the client to scroll and they refuse that. I have tried a page break but it still shows as one page, maybe that is just for printing purposes?
Here is the bottom line of the end result I need:
Open main data entry form: record 1
Enter client data from lookup, enter auto data from lookup (both allowing changes and additions to records) After the last entry on that page is entered I need to go to the second form (or a 2nd screen page, however else possible) and begin entering the parts information for that invoice. This of course needs to be the same record.
I prefer to save the information from page 1 before closing it and going to page 2. So if on the onpush of a button I set it to: save record, open form2, select record # just saved, allow data to be entered on this form ... which new action should I be selecting to focus on the last record saved from the previous form, and do I use 'change record' as my action once I have the appropriate focus?
Thanks. Any suggestions will be greatly appreciated. Also, the customer does NOT want tabbed forms. These two forms need to be separate or at least appear to be on separate screens. He only wants one screen to appear at a time so I will be closing each form upon saving and prior to opening the new form.
Cheryl
Comment