How to copy a value from one table to another

T

Telesphore

In a table tblPassword, there is a list of passwords. Instead of opening
the table of the passwords, select a password, use the function copy, open
the table tblStudents and paste the password in the field, how to automate
the task of the secretaries each time they register a new student in the
table tblStudents?

Thank you in advance
 
T

Telesphore

Thank you,

I created a relation between the field StudentID of the table tblStudents
and the PasswordID of the table tblPasswords. When I try to insert a
password with a form, 8 passwords appear in the drop-down list. That I
choose the first or the 7 others one after the other, no one remains posted
in the control.
 
T

Telesphore

In the table [tblStudents], we have the fields [LastName], [FirstName],
[Street]. and [Password].

In the field [Password], a secretary needs to enter a password to give
access to our web site, so that the student could read his or her school
marks.

Now the secretary is doing this by copying a password from a table of
passwords [tblPassword] already generated by VBA code (there are 50,000) and
by pasting the password in the field [Password] of the table [tblStudents].

It seems it could be easier with a form. Is it? Or by any other means?

Thank you.
 
Top