| | |
|
|
|
Multiple forms for Data Entry |
|---|
| message from Frank on 13 May 2004 |
I have a 2000 access database that has multiple forms for
data entry only. When I get to the last page of entry I
need to save and move to the next record opening the first
form.
Example: record 200 in form "A", progress thru
forms, "B", "C", "D" and "E". On "E" need to push next
record button that will take the user to the next Record
(201) on Form "A".
Any suggestions on how I can accomplish this?
Thanks,
Frank
|
| Byron replied to Frank on 13 May 2004 |
DoCmd.OpenForm "YourFormA", acNormal, , , acFormAdd
HTH
Byron
for
first
|
| =?Utf-8?B?Sm9obiBXLiBWaW5zb24=?= replied to Frank on 13 May 2004 |
This has me a bit queasy. Are these five forms for five tables? or for one abnormally wide table? Are the different forms updating the same record, or related records? How are you navigating from one form to the next?
Typically one would have ONE data entry form, probably with several Subforms for related tables. Rather than closing FormA and opening FormB, you'ld have FormB sitting right on FormA (perhaps on a tab page) as a Subform; the "go back to FormA" scenario would not arise.
|
|
Archived message: Multiple forms for Data Entry (MS Access)
