iggydarsa
Well-known Member
- Joined
- Jun 28, 2005
- Messages
- 1,780
- Office Version
- 2019
- Platform
- 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 ########## -->
<!-- ######### 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
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 | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | EmployeeID | EmployeeName | ||
| 2 | 1 | Alice | ||
| 3 | 2 | Bob | ||
| 4 | 3 | Charles | ||
| 5 | 4 | David | ||
| 6 | 5 | Eric | ||
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
