List Data on Form

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,810
Office Version
  1. 365
Platform
  1. Windows
Hi All,

When it comes to Access I am a newbee, and I need your help.

I have a table called Employee Table

and the data looks like this:
<html><head><title>Excel Jeanie HTML</title></head><body>

<!-- ######### Start Created Html Code To Copy ########## -->

Excel Workbook
AB
1EmployeeIDEmployeeName
21Alice
32Bob
43Charles
54David
65Eric
Employee Table


<!-- ######### End Created Html Code To Copy ########## -->

</body></html>


I want to create a form that lists the Employee names and a checkbox before the name. How can I make my form look like this:

[Checkbox1] Alice
[Checkbox2] Bob
[Checkbox3] Charles
[Checkbox4] David
[Checkbox5] Eric

Of course the checkboxes has to be set in a way that when I check Charles it should send the unique id 3 to the query I will create.

I cannot hard code it because the list might get longer by time.

Any help is appreciated,
Thanks in advance.
Iggy
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Iggy

What is it you are actually trying to achieve?

Sounds to me that you want to select an employee and extract/show data based on which one you selected.

If that's the case then you should probably be looking into using a parameter query.

If you are going to be selecting multiple employees then things are going to get complicated and you'll probably need code.
 
Upvote 0
Iggy

What is it you are actually trying to achieve?

Sounds to me that you want to select an employee and extract/show data based on which one you selected.

If that's the case then you should probably be looking into using a parameter query.

If you are going to be selecting multiple employees then things are going to get complicated and you'll probably need code.

Thanks for the reply Norie,

The tables I will work on doesnt have to do with Employees per se, Just sake of simplicity I decided to go that route.

What I am trying to achieve is, after selecting the employees, I wanna take it to another userform which will ask sets of question based on the employee selection; so yes it will be multiple selections.

lets say my other table looks like this:
<html><head><title>Excel Jeanie HTML</title></head><body>

<!-- ######### Start Created Html Code To Copy ########## -->

Excel Workbook
ABC
1UniqueIDForeignKeyQuestion
211She is old enough?
322He is married?
433Been working long enough?
543Has a middle name?
SubQuestions

<!-- ######### End Created Html Code To Copy ########## -->
</body></html>

SubQuestion.ForeignKey and Employee.EmployeeID are associated

So If I select Alice (1) and Charles (3) on the first screen I should see the new sets of data based on the selection. so the second form should look like this:

[Checkbox] She is old enough?
[Checkbox] Been working long enough?
[Checkbox] Has a middle name?
So that is what I am trying to achieve: get a list of data to display on the second form based on the first selection from the first form.

I hope I was clear.

Thanks again
 
Upvote 0
This is why I was thinking as the first step to populate the user form with the data in a table. How can I do that?
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top