classroom management

[lil2009]

I looked at the classroom management template and on the classes form, when a
student name is selected the major and phone number pop into the subform as
well. How is that done?

 

[Gina Whipp]

lil2009,

Go to Design View of the form and read the code probably located in the
After Update event of the control (that maybe is a combo box).

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[lil2009]

Hi,

I tried looking for code, but I don't see any.

It is a combo box and the dbl click event has a procedure, but it is to open
another form.

In the query that is the record source, If a different student is selected,
the major changes with it.

 

[Gina Whipp]

lil2009,

Is it a form/subform instance? Or maybe the text box that populates with
data has some code? It's hard to day without actually looking at the
template but the the code must be there somewhere.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Not worth a reply...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[lil2009]

If you're going to try to help the OP, you NEED to look at the template.
Otherwise, you're wasting the OP's time stabbing in the dark.

 

[George]

Hello,

WHat is happening there is that the subform is bound to the following SQL
Statement:

SELECT DISTINCTROW [Students And Classes].StudentID, Students.PhoneNumber,
[Students And Classes].Grade, Students.Major, [Students And Classes].ClassID
FROM Students INNER JOIN [Students And Classes] ON Students.StudentID =
[Students And Classes].StudentID;

Selecting a StudentID in the combo box either adds a new record into the
[Students And Classes] table or it updates the existing record. In either
case, the other fields in the query are retrieved from their respective
tables into that row inthe query and, therefore, into the subform.