Search for a suppliers in a table by post code

[stecon]

I have a supplier database with all the suppliers details listed

I want to create a search box on a form wher you enter the first part of the post code ie S75 and it will bring up all suppliers from that post code

Thanks Steve

[debasisdas]

Kindly post what you have tried so far.

[jamesd0142]

I have a supplier database with all the suppliers details listed

I want to create a search box on a form wher you enter the first part of the post code ie S75 and it will bring up all suppliers from that post code

Thanks Steve

Create a database connection

send the sql statement:

[code=sql]select <columnname> from <tablename> where <columnname> like " & "'" & "S75%" & "'"
[/code]