The question of too many codes?

[gear]

I have been wanting to ask this question for long. Is it alright to put too many codes in the various events of the forms and controls? Will it affect the efficient functioning of Access? Will those codes result in any absurd behaviour? For example, I have DMax function in the BeforeInsert of form followed by three If....End If codes. I have not faced any problem so far. However, I just want to hear the opinion of the experts.

 

[Simon_MT]

This is a personal view but I prefer to put transfer the Event Procedures into Modules and call them as and when required. Therefore none of the Forms or Reports have a Module.

I don't often use DMax but even this is in a Module.

The only showstopper I have encountered using Access 97 is "too many databases are open" so to resolve this all the ComboBoxes now defer to a LookUp module to get the RowSource to reduce any overhead. Drop down lists are only populated upon Entry.

Simon