[AccessD] Closing a Form using VBA

Darryl,

Are you aware that the acSaveYes argument you have in your code refers 
to saving design changes to the form, and is not related to the data?

Regards
Steve

Darryl Collins wrote:
> 
> 
> Thanks Steve,
> 
> I have just got this figured out.
> 
> '------- start code -------------
> Private Sub cmdTL_Click()
> 
> If Me.Dirty Then
>     RunCommand acCmdSaveRecord
> End If
> Call OpenTL_Form
> DoCmd.Close acForm, "frm_FYP_APLID_HLSU", acSaveYes
> 
> End Sub
> ' -------- end code ---------
>