Form design question

[StephenSLR]

I am setting up a form for employees to enter data for 'hours' and 'rates' alongside records.

I have nominated the fields as Project, Hours and Rates

In the project field there are subgroups (records) a,b,c,d,e, etc. each with hours and rates applied.

I would like the employees to open up a form and see each unbound record and enter the data for hours and rates alongside in the bound boxes.

i.e.

Field = Project

a) Project planning |Hours| | Rate|

b) Scope |Hours| | Rate|


How do I get the records onto a form as "unbound"?

So far I can only get the fields as unbound.

I plan to have many disciplines i.e. Civil, Mechanical, Electrical, etc. each in a different table with different field headings and different subgroups so will have to make a form for each discipline.

s

s

 

[Pat Hartman]

How do I get the records onto a form as "unbound"?

You need to open a recordset and populate the controls yourself.

You are making a lot of work for yourself. Unbound forms require large amounts of code since YOU have to replicate ALL the functionality Access gives you with bound forms.

I plan to have many disciplines i.e. Civil, Mechanical, Electrical, etc. each in a different table with different field headings and different subgroups so will have to make a form for each discipline.

This can probably be done without creating separate tables for each discipline.

 

[StephenSLR]

I am thinking of making up many tables

i.e.

A table for

a) Project planning |Hours| | Rate|

and a table for

b) Scope |Hours| | Rate|

etc.

Then just putting them all onto a form.

The only problem is each form will be made up of quite a large number of tables and there will be quite a few forms.

Just wondering if there is a simpler solution.

s

 

[Pat Hartman]

Just wondering if there is a simpler solution.

Isn't that what I said? We'll need to know a lot more about the data the tables contain and what it is used for.