I have a linked table that I wish to do a parameter query on using Between [Enter Start Date] AND [Enter End Date]...problem is, my linked table contains a text date field in the format mm/dd/yy....Can't get Cdate function to work here.

I don't suppose you'd consider converting the text date in the linked table to a date/time data type. If not, then you're stuck with getting the CDate() function to work or reformatting the text date and your parameter dates to yy/mm/dd order so that you can do a text compare. As you may have noticed, you CANNOT use the Between operator on this field in its current format if you like acurate results.