open form destroy first record

[eugzl]

When form is ran the fields of first record destroy by value of the form combo boxes that is related to field in the table. If combo boxes is empty it change value of table field to zero. How to fix the problem?



Thanks

[June7]

That is not normal. Is there any code executed when form opens? If you want to provide db for analysis, follow instructions at bottom of my post.

[Gicu]

It looks like you might have a searching combo (to look up records in the form) that is bound to a field in the form's recordsource. The search combo's are always unbound.

Cheers,