Connecting Tech Pros Worldwide Forums | Help | Site Map

Sub-form question

Kevin
Guest
 
Posts: n/a
#1: Nov 13 '05
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
Guest
 
Posts: n/a
#2: Nov 13 '05

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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Closed Thread