Using Function key

[cmw]

Please anybody help me. Is it possible Event action perform using one Function key?
Eg I press F8, Ledger Form open it.
Any sample please post it.

 

[khawar]

Download the attached sample

 

[cmw]

Thank you very much khawar. Work well.Please another one i.e Form data is stored automatically. But I dont want this. Because I click save button Check Required field value it's ok then save form otherwise Message display.I Don't click save button but i close that form or take front record , current record Check Required field value not exist, that record is deleted. How I do it? any idea

 

[khawar]

Check if this helps you

 

[cmw]

You are great! It works well but I dont want save it, form clear then new record open it.

 

[khawar]

I dont want save it, form clear then new record open it.

Cant understand what do you want

 

[cmw]

If MsgBox("Do you want to save this record", vbQuestion + vbYesNo + vbDefaultButton2, "Save Record") = vbYes Then
Else
DoCmd.CancelEvent
End If
Above coding, i want change it Else condition ,i.e I click No button current record clear it . New record open it. If you dont mine, Its my first project in ms access so no idea.

 

[khawar]

If MsgBox("Do you want to save this record", vbQuestion + vbYesNo + vbDefaultButton2, "Save Record") = vbYes Then
Else
me.undo
End If

 

[cmw]

Thank u. works well