I have got a query called students and a subform called student details so i
need to select the student name from the combobox and then based on my
selection i would like the subform to only display the details of that user
e.g. studentId, Course, studentType etc.

This might help...

http://www.regina-whipp.com/index_fi...nkingForms.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

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

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

"display subform records based on combobo" <display subform records based on
(E-Mail Removed)> wrote in message
news:18E63696-B22A-4C7A-9902-(E-Mail Removed)...
I have got a query called students and a subform called student details so i
need to select the student name from the combobox and then based on my
selection i would like the subform to only display the details of that user
e.g. studentId, Course, studentType etc.

Access 2010:
I have a form with a combo box. I have not been successful in populating a subform on this main form. I have a table where I need to select a record from my combo box and have it populate in the subform.Then in the subform I need to fill in a field of this record. Then I need to select another record and have it added to the subform and so on and so forth.
I can select a record from the combo box but it won't populate in the subform.

> On Wednesday, March 31, 2010 3:46 PM display subform records based on combobo wrote:

> I have got a query called students and a subform called student details so i
> need to select the student name from the combobox and then based on my
> selection i would like the subform to only display the details of that user
> e.g. studentId, Course, studentType etc.


>> On Wednesday, March 31, 2010 5:25 PM Gina Whipp wrote:

>> This might help...
>>
>> http://www.regina-whipp.com/index_fi...nkingForms.htm
>>
>> --
>> Gina Whipp
>> 2010 Microsoft MVP (Access)
>>
>> "I feel I have been denied critical, need to know, information!" - Tremors
>> II
>>
>> http://www.regina-whipp.com/index_files/TipList.htm
>>
>> "display subform records based on combobo" <display subform records based on
>> I have got a query called students and a subform called student details so i
>> need to select the student name from the combobox and then based on my
>> selection i would like the subform to only display the details of that user
>> e.g. studentId, Course, studentType etc.


>> Submitted via EggHeadCafe
>> Entity Framework Code-First Library CTP 5 Quick Facts
>> http://www.eggheadcafe.com/tutorials...ick-facts.aspx