FORM FIELD based on another form EASY ???

[jaketsuar]

I have a form that lists employees. I have a add new employee button which opens a blank form to fill in information. I want add new employee form to automatically fill in supervisor information from the first form. Can't figure it out...

[kimmer]

why would you do that? What kind of information? and how does Access know who is the supervisor?

[jaketsuar]

When I created the database, I populated with supervisors names.

All I want to do now is that when Joe Smith begins work, his supervisor clicks on add new record, and joe brown's information (his supervisors name, and telelphone number) populate the add new record form.

Thanks,

[kimmer]

But you said the supervisor names are already in the database. It is incorrect to have them twice.

[jaketsuar]

Guess I am not explaining it right.

This database is very simple. Not difficult where I need relational tables or code to add information.

I have a switchboard with user permissions set. I don't want A seeing B's people and so on.

When I initially created the database, I added the supervisors name to each record. I did this because I have a query that calls the people up by their supervisors name.

Now that it is being used, so the supervisor doesn't have to repeatedly enter his own info, I would like for the info to show up on the ADD NEW RECORD form that pops open when you click a macro called Add New. I would like it to take the supervisors name from Maintenance form and add it to the new record on the Add New Record form.

Thanks.