Hello ,

Thanks for this great piece of code jonathan.

I am trying to customize the query so that i can choose the field instead of name .

//Obtain current parameters
        String sobjectname = System.currentPageReference().getParameters().get('objectname');
        String stext = '%'+String.escapeSingleQuotes(System.currentPageReference().getParameters().get('aname').trim())+'%';
        String sobjectfield = System.currentPageReference().getParameters().get('objectfield');
        
        //Limit Suggestions to 10 Results
        Integer iLimit = 10;
        
     //Validate if there's an input and get results
     
     if(stext.length() > 2){

		try{
	        		
			  String sql = 'select' +sobjectfield+ ' from    '+ sobjectname + ' where '+sobjectfield+' like \''+stext+'\' or synonym__c like \''+stext+'\' limit '+ iLimit;
		         	
		         	for(sobject x : Database.query(sql)){
		        		
		        		String s  = String.escapeSingleQuotes(((String)(x.get(sobjectfield))));
		        		resultsname.add(s);	
		        	}

 I have put in  

String sobjectfield = System.currentPageReference().getParameters().get('objectfield')

and also added  it to the query  but keep getting Unexpected Error, please contact support as result!   if I replace the +sobjectfield+   in the query and just replace name by test_autocomplete__c it just works fine.

The problem seem that i dont know how to assign  the sobjectfield  to the one define in the page.

 <apex:inputField onkeypress="return noenter(event)" value="{!Job_Application__c.test_autocomplete__c}" id="accname" styleClass="cField">
           	<c:autocomplete Width="300" ClassName="autocomplete" InputId="{!$Component.accname}" AutoCompleteId="accACid" ObjectField="test_autocomplete__c"  ObjectName="Job_Application__c" />
           </apex:inputField>

and the component

<apex:component controller="AutoComplete_Controller">

<apex:attribute name="InputId" description="Id of the InputField to which the AutoComplete Componente will belong, use {!$Componente.THEID}" type="String" required="true"/>
<apex:attribute name="AutoCompleteId" description="Unique Id for this AutoComplete Component" type="String" required="true" />
<apex:attribute name="ObjectName" description="This is the lookup Object." type="String" required="true"/>

<apex:attribute name="ObjectField" description="This is the field of the lookup Object." type="String" required="true"/>

<apex:attribute name="ClassName" description="This is the name of the CSS Class used to style the AutoComplete Menu." type="String" required="true"/>
<apex:attribute name="Width" description="AutoComplete Width, In case you need to adjust it for certain inputs" type="Integer" required="true"/>
        
          <apex:actionFunction name="search{!AutoCompleteId}" action="{!searchSuggestions}" rerender="OP_" immediate="true" >
             <apex:param name="aname" value="" />
             <apex:param name="objectname" value="" />
             <apex:param name="objectfield" value="" />
           </apex:actionFunction>
  

I would be very grateful if you could help me out   !