sub-form trouble

[recek05]

hi there i am currently creating a database, based on book for sale. i have four tables (customer details, order details, ordered items, product details) i have created forms for customer details, product details. i have also created a form for order details and have created a sub form inside order details called frmOrderedItems, this sub form contains two field called book names and number ordered. i have entered the infomation into the first record and i clicked onto the next record to carryon entering data but it already has repeated what is in record 1 in all my other 6 records how do i stop this for happening ?

please help

[RuralGuy]

Does the SubForm work correctly by itself? What is the RecordSource of that SubForm?

[recek05]

thanx sorted it

[RuralGuy]

Care to share your solution with others that may read this Forum?

[recek05]

yup ill try explain my problem ihad a bit more.

Problem:

my database was based on book sales inc (customer details, ordered items, order details, product details & ordered items tables,forms & subform)

icreated the customer & product details forms first then created the order details form and used the subform/subreport button, drew the subform in and followed the wizards instructions completed it and everythink, then went to form view and started entering the data in the first record (which contained US Number / Numbered Ordered fields) once i enter the data in record 1:
for example.

US Number: Number Ordered:
US3482 40
US46578 30

iwould move along to record 2 and it would say the same data in that subform, it would do this in all subforms in the 7 different records,which i didnt want because every record had different data to be entered into it. i then try to change the data in record 6 but would still continue to repeat thru all records.

To Solve it:
i deleted all my forms. then recreated the customer and product details forms via the customer & product details table (by clicking on the create tab, then clicking the form button and follow instructions), i then created the order details the same way. once i did this i clicked on the ordered items table, create tab-form button choose the 2fields iwanted (US Number & Numbered Ordered) finished and named it frmOrderedItems subform saved it, went back into the order details for click on frmOrderedItems subform draged and drop in the order details form tested it checked it hadnt repeated the data in the other records and done now im able to eneter the specific data relating to that particular record.

hope this makes sense and helps someone that had the same problem as me =D

[RuralGuy]

Thanks for sharing!

[recek05]

................