Form Auto Fill

[mandy84angel]

tbldistrict (List of school districts...about 40)
tblsite_name (List of school names...about 600)
tblgrade_level (List of grade level...about 5)
tblgrades (List of grades...about 40)

I have the above tables in a relationship with tblschool_info where it pulls
the information via the key and puts it all on one table; along with two
yes/no (checkbox). I also have a query (qryschool_info) of the same
information.

I need to know how I can create a form (frmteacher) so that when I enter a
teacher's information, I can select the school they work at and the rest will
auto-complete based on tblschool_info.

I know I will need either tblschool_info or qryschool_info to do this...just
can't figure out how.

Thank you for the help!!!
Amanda

 

[John W. Vinson]

tbldistrict (List of school districts...about 40)
tblsite_name (List of school names...about 600)
tblgrade_level (List of grade level...about 5)
tblgrades (List of grades...about 40)

I have the above tables in a relationship with tblschool_info where it pulls
the information via the key and puts it all on one table; along with two
yes/no (checkbox). I also have a query (qryschool_info) of the same
information.

I need to know how I can create a form (frmteacher) so that when I enter a
teacher's information, I can select the school they work at and the rest will
auto-complete based on tblschool_info.

I know I will need either tblschool_info or qryschool_info to do this...just
can't figure out how.

Thank you for the help!!!
Amanda

You're apparently making a very common mistake.

You do not need to, nor should you, copy information from these tables into
any other table. Is that what you're trying to do? Don't! Each table should
have its own information; you can (say) *display* the school name or district
or grade level on frmTeacher, but that information should certainly NOT be
stored in tblTeacher (which I presume is the recordsource of the teacher
form).

 

[mandy84angel]

Ken:

tblgrade_level:
(1) Elementary
(2) Middle
(3) High
(4) Charter School
(5) District Office

tblgrades:
K-12, 6-8, 9-12...etc

The two check boxes will tell us what type of auditing needs to be done.
The goal is to have a form, where when we select the school, it will show us
the information attached to that particular school.

These are all separate tables:
tbldistrict (List of school districts...about 40)
tblsite_name (List of school names...about 600)
tblgrade_level (List of grade level...about 5)
tblgrades (List of grades...about 40)

The table tblsite_info is where each of the 573 schools are listed and
foreign keys are tied to the primary key of the other tables to pull the
information for that particular site. The table, aside from the school names,
has all numbers to refer to the other tables. I have qrysite_info set to pull
the information and it works in showing everthing in words, not numbers.

The goal is to have the form show all of the site information by selecting
only the site name. There are from 100-800 teachers for each of the 38 school
districts... having the site information enter automatically will help.

Thank you!