Multiple ComboBoxes on 1 table

[Keefay78]

Is it possible to have multiple Comboboxes running off 1 Control Source table?

My table has 4 columns, "names,dept,phone,address"

first combobox listed by names works fine and i populate the 4 text boxes with this selection

I created another combo and 3 text boxes underneath to select another name but my selection changes the textboxes for the other details too.

 

[arnelgp]

You can't do that in bound combo. That's what it is bound. Any name you select on the combo, moves the record to that name you choose. Use unbound combo.

 

[Keefay78]

If I have it unbound the selected data disappears when the form closes.

Is there a way I could have a form with say 20 combo boxes that would stay selected until manually cleared off?

 

[arnelgp]

if you could post your db, i'd like to have
a better understanding of what you
are trying to do.

 

[Keefay78]

Appreciated.

Here is the db. i have been using the form titled Form with combo and text boxes.

Ideally I would like a list of combos to select multiple staff members.

If i recall if i try it unbound it doesn't show up in report.

 

[arnelgp]

here.
see Form TrainingForm.
the participants are saved in TrainingParticipant table.
added a couple of tables.
see their structure, especially the Numeric datatype.
on table design view you will see that i made them
numeric with Lookup. therefore only their ids are saved.
please study the tables and the forms.
you are far more to go. but your going there.

 

[Keefay78]

Ahhh yeh I see where you are going, I had never thought of it this way, thank you so much.

I will try this way with the information I require and see if I can make it like yours and show you

 

[Keefay78]

Well I tried.. i attempted to re create your forms but ended up just lost.

On your datasheet is it possible to have selections from the columns?
Like first column "Dept" you chose from that selection meaning the next column "role" would display relevant roles available in that dept

I don't know if it can be done. I guess what I need is a form/datasheet with about 5 columns and about 20 rows, that way I can pick someone from each dept, pick thier Role and have their contact details displayed.

It looks like it could be done with your datasheet way. I doubt it could be done with my form and comboboxes as I would have had to create a new control source table for every combobox

 

[Keefay78]

I will have about 200 members of staff in 4 Departments and 3 roles within each department and I need to pick about 20 out every day for this contact sheet

 

[arnelgp]

So what Ur saying is if the person is already on the list, the next day u picked they will be excluded?

 

[Keefay78]

Yeh, we have about 200 staff, 4 departments and each department has 3 role sets.

Each department has to select 6 people (2 for each role set) to be on emergency call.

Each department has a computer and we all share a desktop where the database would be located, each department manager would select the names on the database for their department, every morning.

Once the list has been completed it could be printed out and kept near the dept phone.
(we are in a hospital and we have all been started in this new emergency call in team (now that the world has gone bat shit crazy) so it would be great to know who is on call for each department at the click of a mouse or daily printed sheet.

Hope that helps describe what I mean

 

[Keefay78]

In a way, this is what I am trying to achieve. this type of layout.

none of these boxes are filled, it is purely for display purposes.

 

[arnelgp]

is this what you want to accomplish.
open form FormOnCallsDataEntry and report OnCallReport.

 

[Keefay78]

Wow thanks, I will have a look when I get home in a couple of hours as it is not compatible with the 2007 access here!!

 

[Keefay78]

Unrecognizable to my Access 2007.

I will see if I can run compatibility mode on it

 

[Keefay78]

Ahh I cannot get it to work.

It is just a pity that it is 2007 that is on the work system

Million thanks anyways Arnelgp

 

[arnelgp]

Don't worry I'll try to covert it again tomorrow, it's late, see u.

 

[arnelgp]

i hope you can open this one.
i don't have A2007.

 

[Keefay78]

Unrecognized format.

Arnelgp, thank you so much for trying to help me, unfortunately I can't read the file. We only have 2007 and changing the software is something way out of my hands.

Still very much appreciated.

Sent from my SM-G930F using Tapatalk