Nigel,
How many names do you have to pull off the database?.  If it's not 
hundreds then you could just populate the combobox from a forward-only, 
readonly recordset and use the auto-complete code from my post of a few 
days ago - maybe you missed when you searched the pro_vb archive....?  
Maybe you can modify it to suit you needs.  

If you have thousands of names then this approach is probably not to be 
recommended - don't want to be returning thousands of entries to the 
client!.  Your best bet is probably the 'old chestnut' of gettting the 
user to type in the first few letters and querying the db for the matching 
names.  Otherwise, you could get into screen updating problems, because 
you might not be able to query the db and return the mathcing records in a 
timeframe that is acceptable to the user

HTH,
Andy



 > How do I get a Combo box to auto complete data from a database such 
> as "last name" and when clicked, load the client data into all the data 
> fields. 
> 
> Nigel...