Ah needed to use the .text property
Thanks, This is probably even simpler, but now my little problem is when I do the query in your first sub the Me.Mytextentryfield in the query it is always null. This leads me to get all the records in the database alphabetized in the text box. If I throw...