Subform records issue(critical)

[tahirsatti]

I have two sub forms.First sub form primary key is the link master field in second sub form.When i enter three rows in first sub form and and also start entering values in second sub form then upto 8 records every thing is fine.When i press save button then its complete calculation is fine for save button vba(save button calculation).



But when i enter 9th record in second sub form then there is no calculation after pressing save record.Please tell me is there any record limit in subforms?

Please not that first subform have item names and second subform have size and quantities.

Thanks.

[rpeare]

There isn't a limit (that I've encountered) on records in a subform, it's likely a problem with your code or calculation, especially if you're storing calculated value in your tables. That's a very bad practice and will lead to a lot of problems down the road.

[Missinglinq]

When people start talking about 'save record buttons,' in relationship with Access apps, my first question is always

'are you talking about Bound Forms or Unbound Forms'

since 'save buttons' are unnecessary in Access when using Bound Forms, and the calculations that need to be made, in this case, when a Record is saved, could be made in the Form_BeforeUpdate event.

So, are these Bound Forms or Unbound Forms, and what kind of calculations are being made?

Linq ;0)>

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.