syntax problem with lookup in table

[aussie_user]

I have a database with several tables. I have ID fields for most of my tables. In my main table I have a field called GranteeID. Rather than have the ID number appear in the table I would like the Grantees LastName and FirstName to appear. At prestent in the Row Source box I have keyed in

SELECT DISTINCTROW [GranteeID], [FirstName] & " " & [LastName] FROM Grantees ORDER BY [LastName];

When I look at the Datasheet view of my table, it shows the combined names in a dropdown box however no matter which name I choose, none can be selected.

Can anyone tell me what is wrong with the syntax of my expression?

Thanks for any help.

 

[Pat Hartman]

You'll have trouble with the autoexpand feature of the combo unless you swap the order of lastname and first name or change the sort sequence.

Make sure that all the combo properties are properly set. The first column must be the bound column. The column count must be 2. The column widths should hide the first column. If the combo should be bound to the form's recordsource, make sure that the correct field name is in the combo's controlsource.