Command Button to Show records on form 1

[jminn0311]

Does anyone have some simple coding for a command button that will show records that start with a particular letter. I have a table with a productname field and I want to show only the records that start with the letter "A" in the product field, on the form. I know this is simple but not for me.

Thanks for any help.

Jeff

 

[simon551]

Select Left(FieldName,1)

 

[PHV]

Me.Filter = "[name of product field] Like 'A*'"
Me.FilterOn = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

You may find the Customer Phone List form in the Northwind sample database useful.