Subform Problem (1 Viewer)
- Thread starter sandy70
- Start date
June7
AWF VIP
- Local time
- Today, 07:46
- Joined
- Mar 9, 2014
- Messages
- 5,470
Why use the Enter event of each control to run data calcs? This means code runs as soon cursor enters the control, not when the Enter key is pressed.
This also causes the record to be in edit mode as soon as it opens because of the Enter event code for Keterangan textbox.
Suggest you eliminate the Enter event code for all controls.
The Labor control AfterUpdate code is missing the calc for JumPPn.
Why do you have 2 sets of identical forms?
Need data in the ID foreign key field of ProgressSub if you want more records to display. Advise not use exact same name for multiple fields.
Might want to correct spelling of Custumer to Customer.
This also causes the record to be in edit mode as soon as it opens because of the Enter event code for Keterangan textbox.
Suggest you eliminate the Enter event code for all controls.
The Labor control AfterUpdate code is missing the calc for JumPPn.
Why do you have 2 sets of identical forms?
Need data in the ID foreign key field of ProgressSub if you want more records to display. Advise not use exact same name for multiple fields.
Might want to correct spelling of Custumer to Customer.
Last edited:
TQ June7
My bad with the event
Just delete all Enter event and move the event from enter to After update
Now everything works fine
And sorry for my miss spelling
