Form with buttons

[pascal]

I work in a hospital and I want to make a form witch shows me all the patients in my post. Please open the attachment I've included (it's a word 2000 document) in which you can see how I would like it to be. I saw it on an application at my work but I don't know how this can be done.

tblPatients - PatientID, RoomNumber, PatientName, and so on.

Now. On the form I want to see the patients that are still in the hospital at the moment and when I click on a name on the form I want to open another form to view his data.

Now, how can I fill in the buttons on my form with the right names (in a format like the document I've included)? How can I get the names out of the table and put them on the buttons?

Thanks in advance.

 

[SforSoftware]

Hi Pascal,

On what criteria do you want the columns to be located? In the attached document I don't see directly which columns (fields) you want to put on one line.

I'd think to do it with a cross-tab-query, with three columns. Then you create a continuous form based on that query. For the names you can use standard textboxes instead of buttons. They've also a click- and doubleclick-event to open the second form.

 

[pascal]

Thanks Bert for the quick reply.

First of all. The only criteria on what the columns must be located is only the patients that are still in hospital. Let's say with a YES/NO field called StillInHospital.

On each button or textbox I like to see the names of the patients still in hospital according to their roomnumber. The roomnumbers are put on the buttons or textboxes with a label in the design view already. The 3 columns you see is just an outline presentation.

I hope I've given you the correct answer to your question Bert, cause I don't quite understand what you mean with which colums I want to put on one line.

 

[WayneRyan]

pascal,

Is that the entire population of rooms? Is it possible for
you to get someone on the 2nd floor? If you are going to
represent them with objects, it would help to know if there
are a static number of rooms.

Wayne

 

[pascal]

That's indeed the entire population of rooms in my service.
What do you mean with getting someone on the 2nd floor?

There are a static number of rooms.