Product Information Forms

I am looking to create a form to input Product Specification Details. So when
looking at the product on the order sheet/table I can double click the
product and the Product Specification form with pop up (kind of like a
subdatasheet of contacts information on a customer table)

What I want is the header of the the form to have the Product name and the
Customer name, and then the details of the form to contain information such
as product weight, size, contents (which can be a selection of 8 different
options)

I have designed the form already but when I put information into the details
part of the form it stays the same for all products. Do I have to link the
form to a table (even though I dont really want a table)?
--
Thanks
WoodyAccess

Hi WoodyAccess,

I have been through the process of designing a customer Form recently,
and I have the CustomerID in the header of the form, that is changing
without any problem as the rest of the form is changing from customer.

I would suggest that you try from scratch:

1. create a from is design view,
2. in the properties set the recordsource as your table customer,
3. enable to view the header/footer of the form
4. just drag and drop the field you want from the table onto the form,
5. copy and past the fields you want into the header/footer.

Hope it helps

Tam

WoodyAccess wrote:
I am looking to create a form to input Product Specification Details. So when
looking at the product on the order sheet/table I can double click the
product and the Product Specification form with pop up (kind of like a
subdatasheet of contacts information on a customer table)

What I want is the header of the the form to have the Product name and the
Customer name, and then the details of the form to contain information such
as product weight, size, contents (which can be a selection of 8 different
options)

I have designed the form already but when I put information into the details
part of the form it stays the same for all products. Do I have to link the
form to a table (even though I dont really want a table)?
--
Thanks
WoodyAccess

It was slightly helpful in comfounding my thoughts that a table is needed,
and that I couldn't just use the information to only appear in the form and
not in a table.

Do you happen to know if i make a certain selection in a combo box how I
could then cause other field boxes to not allow data to be inputted in them?
--
Thanks
WoodyAccess


"[Tourist].Tam" wrote:

Hi WoodyAccess,

I have been through the process of designing a customer Form recently,
and I have the CustomerID in the header of the form, that is changing
without any problem as the rest of the form is changing from customer.

I would suggest that you try from scratch:

1. create a from is design view,
2. in the properties set the recordsource as your table customer,
3. enable to view the header/footer of the form
4. just drag and drop the field you want from the table onto the form,
5. copy and past the fields you want into the header/footer.

Hope it helps

Tam

WoodyAccess wrote:
I am looking to create a form to input Product Specification Details. So when
looking at the product on the order sheet/table I can double click the
product and the Product Specification form with pop up (kind of like a
subdatasheet of contacts information on a customer table)

What I want is the header of the the form to have the Product name and the
Customer name, and then the details of the form to contain information such
as product weight, size, contents (which can be a selection of 8 different
options)

I have designed the form already but when I put information into the details
part of the form it stays the same for all products. Do I have to link the
form to a table (even though I dont really want a table)?
--
Thanks
WoodyAccess