subform help pleeeeeeeeeease

[Gazza2]

i have posted a copy of the forms that i need some help with.

basically the part no text box at the bottom is used for entering part numbers from the product details table and displaying them in the subform, but i can only get the subform to display either every part no or can only get it to display 1 part no and then it disappears when i go to enter a second which i dont want.

It would be much appreciated if someone could take a look and give me some advise on how to set the code up.

The format of the form cannot change as i have some other things that need to be sorted later on once i have sorted this serios headache of a problem

 

[Dave Eyley]

What links the two forms?

There should be a common fieldname to both main and subform listed in the properties or in the main forms code...

Dave Eyley

 

[Gazza2]

Part no links the two forms.

 

[Dave Eyley]

I've looked at the form and it appears that there are no linking fields between the main and sub form since the main form holds only the Customer details and the subform holds the parts details.
I don't understand the logic behind the subform operation. I would re-think the design...

Dave Eyley

 

[Gazza2]

the subform is used for a price check when customers phone up to check prices. I just need to enter a bunch of part nos and have them displayed in the subform along with there prices and a total price at the end.

thanks

 

[Sergeant]

Sounds like a job for a listbox and the .additem method.

Not sure if you can sum a column in a listbox?