Subform Problem

[sandy70]

Can somebody help me with my subform plz

I dont know what wrong with the form

My subform only can have 2 record only

Need to reopen the form to add another record

Plz take a look at my form

 

[June7]

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.

 

[sandy70]

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.

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