Form

[Savanah]

I have 3 tables
Protocol Protoid protoname etc
Subject subjectid protoid lastname firstname address ect
Week weekid week protoid

I am doing a ENROLLMENT, so I did a form based on Protocol and a subform
based on Subject. So I want a combo, where I can choose the protocol and the
subform shows me the subject enrolled and I want to enroll a new one.
Problem:
the combo box for the protocol doesnt drop all protonames, and I dont want
the user use the arrows on the bottom.
I seached for this matter but one did not work. Any help will be
appreciated. Tia

 

[Savanah]

I codded the combo box on the Enter event:

Me!ComboName.Dropdown
and I got error

 

[Savanah]

I seacherd at ORder entry database model and is almost the same conception,
but my subform is editing.Tia