Letter Search for field

[Jackson M via AccessMonster.com]

I have buttons name A thur Z - When I select say the letter "H" button I need
my ProductName field to jump to the record that starts with the letter "H"
and soforth. Can anyone help

--
This Message Is Coming To You From Sunny South Padre Island, Texas
Message posted via http://www.accessmonster.com

[PC Datasheet]

For purposes here, I am using FrmMyForm as the name of your form.

1. Use the Toolbox wizard to create an option group with Labels A to Z
2. Use Toggle buttons
3. Make sure the names of the Toggle buttons are Toggle1 to Toggle26
4. Name the option group "MyOptionGroup"
5. Create a query that will display your ProductName field and any other
fields you want
6. Put the following expression in the criteria of your ProductName field:
Like (Forms!FrmMyForm("Toggle" & Forms!FrmMyForm!MyOptionGroup).Caption &
"*")

The query will return all product names beginning with the letter you click
in the option group.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Jackson M via AccessMonster.com" <fo***@AccessMonster.com> wrote in message
news:53***********@AccessMonster.com...

I have buttons name A thur Z - When I select say the letter "H" button I
need
my ProductName field to jump to the record that starts with the letter
"H"
and soforth. Can anyone help

--
This Message Is Coming To You From Sunny South Padre Island, Texas
Message posted via http://www.accessmonster.com