Sub-form question

[Kevin]

Hello Access experts,

I am using a database that another programmer created. It has an order
form with a subform that contains details of the order such as
palm-pilot, laptop, camera etc. When I add a new order on the main
form, it works well till I enter the sub-form at which time it
abruptly jumps to some other order and brings up the order details for
that on the sub-form. Have no idea what in the wide world is
happening. I checked the OnEnter event of the subform. It has some
code in it for error-handling but nothing for this magic.

I am lost. Any clues will help give me a direction. I thank you for
your advice.

Kevin.

[MGFoster]

Re: Sub-form question

Kevin wrote:[color=blue]
> Hello Access experts,
>
> I am using a database that another programmer created. It has an order
> form with a subform that contains details of the order such as
> palm-pilot, laptop, camera etc. When I add a new order on the main
> form, it works well till I enter the sub-form at which time it
> abruptly jumps to some other order and brings up the order details for
> that on the sub-form. Have no idea what in the wide world is
> happening. I checked the OnEnter event of the subform. It has some
> code in it for error-handling but nothing for this magic.[/color]

Check the main form's BeforeUpdate and AfterUpdate events and the
subform's Current event to see what they're doing.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)