The question is. I have a form that half the data is the same and I want it
to recur. example I have different users at different locations.
When "john" opens the form I would like it to prompt him for his name, date,
and department. Then this info would recur through each record that he
enters while this form is open. Then he could close the form and Susie could
do the same. I can set up defaults in forms to do this but I need the these
to be chosen from drop down menus. So that the data is the same each time.
There are multiple users for this data base. Each user would be entering in
around 60 records per session

Have you ever thought about using an LDA? (local data area), used alot
in other types of programming. I use is quite often to do basically
the same thing you are saying. But I do it based on a sign on screen,
the user will sign on to the system, I do lookups and capture all the
information that I need and store that information in what I refer to
as an LDA form, which is open but hidden. They whenever I need the
information, such as filling in a form or certain fields I can easily
grab it and populate that information.

John




"Doc" <doc______ (AT) hotmail (DOT) com> wrote