ordered listbox key selection

antonyx

Arsenal Supporter
Local time
Today, 17:16
Joined
Jan 7, 2005
Messages
556
hi, just wondering if anyone can show me an example of what i am looking for cos im not what to search for.

i want to create an ordered list..

eg

1 company 1
2 company 2

etc..

when my user presses the 1 key, it chooses company 1, etc.

i realise i would have to make a listbox with my chosen items and then have an on KeyPress rule attached to it. (i think)

how would i go about placing a basic counter in that list, 1,2,3, to act as selectors..

anyway, if anyone can give me a bit more info, please do

thanks
 
Uncle Gizmo

I have been looking at the demos you supplied and am having some trouble converting them for my own db.

I have a table of customers (tblcustomers) and two fields accountcode and customername.when i try to change the query to suit my db and i try to open it i get an enter parameter box asking for accountcode.

Heres the original line:

Sequence: DCount("AuID","Authors","AuID <=" & [AuID])

And heres what i changed it to

Sequence: DCount("Accountcode","Tblcustomers","Accountcode <=" & [Accountcode]).

When i enter an accountcode into the parameter box it returns an error message saying it cant find accountcode (i have attached a picture to show you).

Any ideas on where im going wrong as your example doesnt even ask to enter anything.

Thanks in advance for any help.
 

Attachments

  • Error.gif
    Error.gif
    14.7 KB · Views: 172

Users who are viewing this thread

Back
Top Bottom