Recent content by alexriverajr

Thanks for the help. I saw what you did and that helped me learn.

Thanks. I appreciate you help!

The field is indeed called SearchName, below is the DB. The form in question is frmMainFormSearchGuest. In included is the file, warning this is work in progress as i'm just learning. Thanks

This is what I have now and I removed the filter from the query but nothing works now: Private Sub SearchName_Change() If Len(Me.SearchName & "") >= 3 Then Me.Filter = "" Me.FilterOn = False Me.Filter = "[SearchName] Like *" & Chr(34) & Me.SearchName.Text & Chr(34) & "*" Me.FilterOn...

Whats the end if as the bottom. Do I need to put in some type of parameter or argument? Thanks

I used the re-query command and it updates only when i'm out of the field. I would like to able to remain in the field. For example, with re-query I have to click on the tab key and then it updates vice when I was using refresh it would filter the items containing the type letter but it wouldn't...

This what I have in the OnChange event pro: Private Sub SearchName_Change() Me.Refresh End Sub And this what I have in the query which the text box filters: Like "*" & [Forms]![frmMainFormSearchGuest]![SearchName] & "*" I'm just trying to do a filter as you type textbox. Thanks in advance.

I'm trying to do the same but where would I be able to change these features. So far I have the OnChange but it only allow me to type in one letter and no more.

I have tried this: =DLookup("[FirstName] & ' ' & [LastName]", "Guest", "GuestNo = '" & [Reservations.GuestNo] & "'") But I get a mismatch error. Is there something glaringly wrong with this. Thanks

I'm trying to create an expression that filters out records based upon a selection in another column. Im kind of lost on where to start. Just an example of what thinking: Selection from row a filters a number of records that meet that selection. Hope this illustrates what I'm trying to...