Subform lookup

[macinjosh1]

Hi.



I'm working on a contact management database, and I'm having some problems on a subform. On the calls subform, I'm trying to get a combo box to list all of the names from the students table, full name column. But when a name is selected, it's changing all of the rows in the subform, not just the one record. Can someone help me on this?

Thanks.

Contact Database.zip

[Jester0001]

I noticed that on your Calls table, the data type for the field Student Name is set to Number (Long Integer). This is the first problem. You'll have to delete the relationship to this field, and change the data type to Text. Then, re-establish the relationship.

Second, you don't have a control source for the Student Name field. (try using Student Name as the control source)

Third, and I'm not sure if this is necessary, but I used this as the Row Source: SELECT Students.FullName FROM Students;

Now, you should have a combo box to select the student names for the Calls Subform.

[macinjosh1]

Woot! Worked like a charm. Thanks. One last thing, I'm trying to get that field to show up on the Open Student Referral report, but it's not working. I'm typing in the same stuff, but the names aren't showing up. Thoughts anyone?

Thanks.