Command Button that looks up field and displays in text box

[Nuke1096]

What I'm looking to do sounds very simple, but I'm having some trouble figuring things out. I'm still very novice with access and programming

I want to create a series of command button so that when clicked on, it looks at a table, associates the Primary ID in the table with teh specific command button its for, then displays a specific field in a text box.

So to try to visualize it.

I have 4 Command Buttons on my form, each labeled...

Department 1
Department 2
Department 3
Department 4

Then a Department Table created with three fields, with a total of 4 rows, one for each Department. The fields are...



Department ID
Department Name
Department Phone Number

So I want to be able to click on say the Department 2 Button, which will then look into that table, recognize that the 2nd Department ID is tied to Department 2 Button, then pull the Department Phone Number for that row, and display it in a text box.

Anyway help is greatly appreciated

[rzw0wr]

A combo box may be as good or better for this.

Dale

[Nuke1096]

The way the form is setup, a combo box wouldn't really work for how I want everything displayed