Repeat fields from one form to the next.

[JohnJ]

I have a small database in which staff complete a form to make budget submissions. Often staff have to use more than one form (i.e. make more than one submission). How can I get the staffname, campus and faculty details from the first form automatically show on the next one and so on. Its O.K. that for the first form in any session these fields get entered but after that its a bit trying especially if there are many submissions to make.

Any help would be greatly appreciated.

John
Melbourne, Australia

 

[Pat Hartman]

Perhaps you should be using a mainform to collect the static information and a subform to collect the variable info.

 

[JohnJ]

Thanks for your reply Pat. I will try the form/subform idea.

John

 

[JohnJ]

In the end I didn't use Pat's uggestion but rather the simple, and to me elegant, solution proposed by 'raskew' in his reply of the 9th June 2001 to a similar problem. This solution results in a control, after updating, making its contents the default contents for the next form. Thanks raskew.