I Hate "Where" Clauses !

I need some help with a Where clause in a SQL statement.

What I am trying to do is use a value that is displayed in a text box on my form as the filter criteria in a list box.

On my first form I have the user select his username from a combo box. He is then prompted for a password. Once he gets past the password form, it allows him access into the main data entry form. Once he's in, the UserID he selected from the first form is automatically displayed in a textbox known as [Text689]. This text box is set to Enabled.False so it can't be changed and it's control source is set to the table as UserID.

I have another listbox setup on the main form as a record selector. This is where it gets confusing. I can get records with no problem, what I can't figure out is how to limit the records the user can select, to what he actually has created. I want to filter his selection options based on his UserID.

I have tried everything I can think of and nothing seems to work. I think the answer lies in the where clause of my SQL statement but it continues to elude me.

example:

Select tblFTEP.[Key#],tblFTEP.UserID,tblFTEP.TraineeID, tblFTEP.DOR,tblFTEP.Date
From tbl FTEP
Where ???????? ;

What I want the where condition to say is, show only those records that match the UserID that is displayed in Text689 on the main form.

Any ideas? I am just about ready to throw this laptop out the window!