Forms/Subforom

[Guest]

I'm pulling out my hair with this one...

I have a form that you can select the ProductType and then can fill in the
different products the their prices below. I have it set up using a
form/subform format.

The form is just a combo box with a list of the producttypes. It is based
on TypeTable that have one column simply listing the product types.

The form is 8 rows of fields that list the product and its price. It is
based on ProductTable that looks like:
Type Product Retail wholesale
1 a 2 3
1 b 1 4
1 c 7 9
2 a 1 4
2 b 4 8 .....

But, this doesn't allow me to input new items. For instance, when I type in
a producttype that wasn't originally included from the box the subform just
doesn't appear so I can't enter in new data.

I am just learning Access basically by going through a sample database and
it seems that I might need to base the subform off a query that is based on
some of the information in the ProductType table.

I know this is coming out kind of complicated but I have another form that
is having a similar issue and I am at a dead end. Any ideas and/or help
would be great! Thanks.

 

[kingston via AccessMonster.com]

When you type in a new product type, the record must be saved in order for
the subform to work. This can be done simply by moving to another record in
the main form and then moving back, or you can use the product type textbox's
AfterUpdate event to check if the entry is new and to save the record.