Access 2002 combo box problem

[Guest]

Hi,
I added a combo box using the wizard, that is linked to a table into a sub
form that is linked to a query. When I make a selection from the list it
populates all the records with the same selection. Has anybody seen this
before? What can I do to have it enter the
individual data in each form?

Thanks,

 

[Ken Snell \(MVP\)]

I am assuming that the combo box is in the subform?

Be sure that the appropriate field's name (the field that is to be updated
with the value from the combo box) is in the combo box's Control Source
property.

 

[Guest]

Yes the combo box is in the subform.

Thanks for the reply, another problem arose:

When I use the drop down arrow to make my choice the selection is
highlighted but does not appear in the box.

Control source: =tblRequest!CertType
row source type: Table/Query
Row source: SELECT tblCertificationType.CertType FROM tblCertificationType;

 

[Ken Snell \(MVP\)]

You're using an expression as the Control Source, which means that you
cannot change the value in the combo box:
Control source: =tblRequest!CertType

Assuming that you want the selected value to be put into the
tblRequest!CertType field, which I assume is a field in the subform's
RecordSource query, change the Control Source to this:
tblRequest.CertType

 

[Guest]

Its working fine now.

Thanks,

You're using an expression as the Control Source, which means that you
cannot change the value in the combo box:
Control source: =tblRequest!CertType

Assuming that you want the selected value to be put into the
tblRequest!CertType field, which I assume is a field in the subform's
RecordSource query, change the Control Source to this:
tblRequest.CertType