search criteria

  • Thread starter Thread starter Haigy
  • Start date Start date
H

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
 
never tried this, thanks

new it would something simple

Marshall Barton said:
Haigy said:
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
Click to expand...

Did you try this?
. . .
WHERE tblInsolClients.[Name] Like
Forms!frmClientSearch!txtSearchClients & "*"
. . .
Click to expand...
 
Haigy said:
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
Click to expand...

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