Thanks, that worked perfectly.
Now I have a questions that is on this same form but with the Dynamic Dropdown part. I am wanting to filter the Recordset that will fill the first List in my Dyanmic Dropdown. I want to fill in a text field that will be the form variable that filters the recordset. I already set the recordset to form variable and to begins with. Now how do I do the rest?