Data Entry Problems

[jenvandiver]

Hello, thanks in advance for any help on this...

I'm trying to create several forms for data entry. For example, the first one will collect general information from the user. A button on that form will take them to the next form where they enter information about another related area. What I would like is for these forms to all link together into one record in one table using the same ID number - then have a final form (which is NOT a data entry form) show all the information from that one record for the user to confirm/edit their choices.

I'm having trouble because some of the forms aren't saving the information into the same record in the master table. I'll have half the information in the record from Form 1, then the other half in a different record. Also, I can't get my last form (confirmation form) which is linked to the table to show all the data for that one record.

Am I missing something simple?

Thanks!

 

[LHR]

Jennifer,

You could do this with many forms or try seperate pages in one form and use goToControl on the lost focus of an object.

If you use seperate forms you have to make sure each form is open to pass the value of that form to form that collects all the data. I'm not sure how many tables you are referrign to but if they are all related one form may be more helpful.

Once the info is gathered then you can either use a subform with properties such as allow additions and allow edits set to false

or

Display another form that shows all the fields you want after you have entered them on the previous form. You can do that based on some unique value you put into the record.

Hope this helps!

LHR

 

[jenvandiver]

So you think I should use one form with several "pages" to collect the information, then at the end open a new form for the user to confirm all their choices? I just figured it would be easier for them to complete some information, move to the next form, etc - rather than having to continue scrolling down one long form.

I appreciate your advice!

 

[LHR]

If you use a GoTo Control it you can create the movement for them. ON Lost focus GOTO Control and they are in teh next location.

No scrolling necessary unless they want to.

Good luck!