Forms

[Guest]

I have a table with the following fields:
Site, Week, Product, Weight.

I am trying to get a Form to allow easy data/editing by product.

I have a site which produces a number of products each week. I am getting
the site to input how much product they expect to produce over the next 14 -
18 weeks.

I would like to get the sites to enter the data like this -

Site
Product

WEEK WEIGHT
Week 1 KG
Week 2 KG
Week 3 KG
Week 4 KG
Week 5 KG
Week 6 KG
Week 7 KG
Week 8 KG

Select a site and product and the individual weeks are displayed for editing.

Currently the form allows me to enter the data in the following format:

Site
Product (a)
Week (week 1)
Weight

Site
Product (a)
Week (week 2
Weight

Site
Product (a)
Week (week 3)
Weight


If I have 15 products I have to go through each one by week before I can
move onto the next product.

Ta

 

[SteveS]

Have you thought about using an unbound form with unbound controls.
Use combo boxes for the site and product, and text boxes for the week & weight
entries.

Add a button to save the data. The button on-click code would loop to create a
new record for each of the 8 weeks.


HTH