Searching in Combo Field

[Mango1]

I have a form with a Combo Field that comes from a query. The Query contains several fields of which includes: Formal FullName, LastName. Within the form, the combo field is bound to Formal FullName. BUT, I'd like to be able to click on the field and type the last name or part of the last name to narrow down my search within the field. Then, once narrowed down, click the Formal FullName to enter it into the combo field. How can I do this?

 

[Everton]

Hi,
Something like this might be what you're after, on the afterupdate event of the lastname control, change the rowsource of the formal fullname like this:

Me.[Formal FullName].Rowsource="Select * from [Query] where lastname=" & me.[lastname]

me.[Formal FullName].requery


HTH,
Paul.

 

[Mango1]

appreciate all the help. Will try each to see which works best for me.