Creating a form within access that updates another form?

[Celx]

Hello,

I'm just learning access 2010, and I think I can understand the basic concepts, however it would be ostentatious of me to pretend I'm an expert, so please bear with me if I misunderstand concepts as I'm a novice.

Regardless I wanted to ask whether it would be possible to create a form for a receptionist wherein the information fields she inputs could automatically be updated to a separate form that an administrator would have private access to.

I understand that a form can be password protected, and one can build a relationship between forms, but I still am not sure about the exact process in regards to the ladder.

Would I just use the "relationships" ribbon panel to link the forms together, or is this something that will involve queries, or something else entirely.



The example below will hopefully describe what I would like to achieve:

As it's updated and new entries are entered into form A). that information is then automatically relayed into the private password protected form B). who's information is not shared with any other forms and has additional fields to be filled out by the administrator.

If this is possible please give me a general idea of what concepts I should look into in order to get this kind of structure developed.

Thanks!

[hertfordkc]

The receptionist would input data which would update tblPartialNfo. The supervisor would have a form which would query tblPartialNfo and display each record to be completed. Each completed record would be stored in tblAllNfo and the unfinished record removed from tblPartialNfo.
That might remove the need for concurrent processing.

[Celx]

Thanks for the response, just one more question before I get onto the task of building this thing...

Would it be possible to password protect the administrator table & form?

Thanks again!
- Celx

[hertfordkc]

beyond saying that you should be able to implement a security scheme that would keep most users in their boxes.