have a 2007 ms access database with two tables: tLocation01 and tLocation02. tLocation01 has 1134 records and tLocation02 has 1194 records. The tables have the same exact structure: LNAME, FNAME, and FULLNAME.
Now I have a CF form with two fields:
Location 1 Name: text field with autosuggest turned on
Location 2 Name: text field with autosuggest turned on
A data entry person will enter the full name of the person from either Location 1 or Location 2. With autosuggest on, the data entry person only enters a few character before the full name is displayed. The code for autosuggest field is exactly the same except for the recordset name: rsLocation01 and rsLocation02.
autosuggest="#ValueList(rsLocation01.FULLNAME#" for field 1
autosuggest="#ValueList(rsLocation02.FULLNAME#" for field 2
Field 1 autosuggest works and bu not Field 2. However, if I view the View Source option in IE and Firefox, I see all the names in Location1 and 2.
Anyone have an idea what is going on? Is there a autosuggest limit?