I made a form into a keypad, but each button is a department button,
I have a table for departments numbered 1 - 16, they are linked to the order details by a foreign key (department ID in the Order details form)

how would I be able to do the following:



On click of the department box (in the actual form) brings up the keypad.
the press of a button returns a relavent number (i.e. dept 1 returns "1")
This number is stored in the department ID, and thus displays the department Name in the department box I just clicked on
The keypad closes

Does this sound possible?
Bare in mind I'm not an avid VB user, so keep your answer simple, thankyou.

Can you prepare a little sample of forms I will try to code them

Hope this is enough

Download the ammended file

Open form QryOrderDetails

Double Click on the departmentId or Name Field (if you want it on single click choose the event and copy the code)

Department Keypad will open

Click on the department you want to select

Thats all

That works great! Thankyou! :)