Using option group macro to alter data in List box?

C

CP

I have sampled Northwinds Telephone List
Copied the A-Z option group onto my form and copied the macro into my
database

I want the A-Z buttons to alter data in my list box I have created ie. Press
button "P" the list box only shows Data starting with P

Conditon in Macro - [Customer] Like "P*" - (note seperate condition for each
letter)

The list box finds data on my form using the following
SELECT [Customers Query].Customer FROM [Customers Query];

I am trying to limit the list down to a more reasonable level using the
option group.

Macro - [Customer] Like "P*" - I get 'there is no field called "Customer" in
the current record
Macro - [List6] Like "P*" - I get a box asking for list6 parameter - list6
is the name of the list box
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Word OLE to check spelling in text box 1
Going to last record saved in list box 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Using the list form control: multi-selection possible? 3
I'm trying to remove duplicate phrasing and words using VBA in Word 2
Option Groups: Can I Group the Buttons AND the Box They're In? 2

Top