create columnlike structure in form?

H

Henrootje

I have a form with data concerning companies:
SELECT CompName, adress
FROM tblCompanies

I have a subform that shows all the employees of these companies:
SELECT EmpName, function, company
FROM tblEmployees

A company can have up to 12 employees
I understood frome reading several newsgroups that forms cannot have
columns
(very please, correct me if I am wrong!!!!!)

So I had the idea of creating three identical subforms, the first
showing the first 4 employees, the second showing employees 5-8 en the
third showing employees 8-12

All I can find is how to sort the top 10 but I am not interested in
that, I just want to create the effect of a 'snake-column' on my
form...........

Any suggestions?

TIA, Henro.
 
H

Henrootje

I do know how to create subfiorms.
The question is how to limit a subform to records 1-4, a second to
records 5-8 and a third to records 9-12

But thanks for thinking with me


Wayne-I-M schreef:
 
N

NthDegree via AccessMonster.com

Henrootje said:
I have a form with data concerning companies:
SELECT CompName, adress
FROM tblCompanies

I have a subform that shows all the employees of these companies:
SELECT EmpName, function, company
FROM tblEmployees

A company can have up to 12 employees
I understood frome reading several newsgroups that forms cannot have
columns
(very please, correct me if I am wrong!!!!!)

So I had the idea of creating three identical subforms, the first
showing the first 4 employees, the second showing employees 5-8 en the
third showing employees 8-12

All I can find is how to sort the top 10 but I am not interested in
that, I just want to create the effect of a 'snake-column' on my
form...........

Any suggestions?

TIA, Henro.
Click to expand...

Yes, forms can have columns (and rows if needed), it just requires a little
Access magic.

Create your 12 text boxes for your employees (and for the other fields if you
want to show function and company and name them like:

Employee1
Employee2
 
Top