Lookup using Unbound Combo

[dmyoungsal]

In my form, I have a combobox (cboFind) that I use to lookup records and it works like it should.

I needed to add another field to allow our users enter the Contract# and on my inquiry screen, I added another field allowing the user to look up records (in the same table) based on the Contract# (cboFind2).

I can start entering a contract # and the cboBox begins listing the records that have some potential matches.

The issue is that when I select one of the records and press enter, the desired record does not display.

What am I missing in this process.

This is the select Statement:
SELECT tblTranCalc.ID, tblTranCalc.[Contract#] FROM tblTranCalc ORDER BY tblTranCalc.[Contract#];

 

[static]

Your sql has no WHERE

SELECT tblTranCalc.ID, tblTranCalc.[Contract#] FROM tblTranCalc WHERE myfield='somevalue' ORDER BY tblTranCalc.[Contract#];