Using a List or Combo box to populate a field

[Michele]

I am trying to use a list or combo box containing and
autonumber(Project ID), on a form, so that when the
particular number is selected the rest of the form will
populate with that record information. Under properties
of the box, for row source I have the following
expression:

SELECT DISTINCTROW[tblinfo].[ID],[tblinfo].[LTS
scientist],[tblinfo].[Project Name]...(for a fields in
need populated)FROM[tblinfo];

Is this wrong? any suggestions on how to make this work.
Thanks for your help
Michele