search criteria

[Haigy]

i have form with a list box and text box on it

i can get the list box updated when you enter the correct surname, ie smith,
what i need to do is enter the first few initials or the first letter and it
will bring up all names starting with the letter in the text box

sql is

SELECT tblInsolClients.ClientID, tblInsolClients.Forename,
tblInsolClients.Name, tblInsolClients.HomePhone, tblInsolClients.Mobile
FROM tblInsolClients
WHERE (((tblInsolClients.Name) Like
[Forms]![frmClientSearch]![txtSearchClients]))
ORDER BY tblInsolClients.Name;

no matter where i add the wildcard "*" i cannot get it to work

please help

thanks in advance

 

[Haigy]

never tried this, thanks

new it would something simple

i have form with a list box and text box on it

i can get the list box updated when you enter the correct surname, ie smith,
what i need to do is enter the first few initials or the first letter and it
will bring up all names starting with the letter in the text box

sql is

SELECT tblInsolClients.ClientID, tblInsolClients.Forename,
tblInsolClients.Name, tblInsolClients.HomePhone, tblInsolClients.Mobile
FROM tblInsolClients
WHERE (((tblInsolClients.Name) Like
[Forms]![frmClientSearch]![txtSearchClients]))
ORDER BY tblInsolClients.Name;

no matter where i add the wildcard "*" i cannot get it to work

Did you try this?
. . .
WHERE tblInsolClients.[Name] Like
Forms!frmClientSearch!txtSearchClients & "*"
. . .

 

[Marshall Barton]

i have form with a list box and text box on it

i can get the list box updated when you enter the correct surname, ie smith,
what i need to do is enter the first few initials or the first letter and it
will bring up all names starting with the letter in the text box

sql is

SELECT tblInsolClients.ClientID, tblInsolClients.Forename,
tblInsolClients.Name, tblInsolClients.HomePhone, tblInsolClients.Mobile
FROM tblInsolClients
WHERE (((tblInsolClients.Name) Like
[Forms]![frmClientSearch]![txtSearchClients]))
ORDER BY tblInsolClients.Name;

no matter where i add the wildcard "*" i cannot get it to work

Did you try this?
. . .
WHERE tblInsolClients.[Name] Like
Forms!frmClientSearch!txtSearchClients & "*"
. . .