Data Entry using SubForms

[TheWebDataGuy]

I got a data entry form with a subform. Order Details on Main form and Product Details on SubForm. Both are linked by OrderID. Order table has OrderID as PK while ProductDetail table has ProductID & OrderID composite PK.

My problem is that when I set Data Entry porperty to Yes I donot see anything in either form view or datasheet view. If the property is set to No, I can atleast view records on form but cannot add record.

How do you add record into two tables from one form? Why do I see blank form???

 

[Haitham]

Hi,

Yes Sure If you set your data entry to true you'll get that problem.
Then, you have to set your form controls enabled to false, and that time you can just do jumping throgh your record's.

Good Luck