problem solving

[raychoy2k]

Hello,

I am stuck trying to solve this problem with access.

I am creating an invoicing system. In a regular invoice, there would be multiple lines of different products that are purchased
( ie qty, item number, description, price, extended total). I created a form to hold all the customer info for that particular invoice. But for the products, I don't want to create all the fields to hold the info for the products in the same invoice table. Main reason is because it would be static and I can't add more products to the table than what I created room for. So my idea is to use a subform (new table) to store that info. And each record is a line holding the info described above and it is related by an invoice number field. This way its scalable and I can add as many products to an invoice as needed. Problem is, in datasheet view, I cannot add code to respond to the events (ie calculate the extended total price, qty*price, when I tab out) Hope this makes sense. Sorry for making it so darn long.

Any suggestions would be great.

 

[neileg]

Create your subform as a continuous form instead of datasheet.