Event procedure on selection

[guinness]

Can't quite get my head round how to write this but I know it can be done.

I have a form with a field called duration.
The user selects AM,PM or All Day from a list
If the user chooses All Day I want to create a duplicate record

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdRecordsGoToNew
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdPaste

However I would like the duration in the first record to be AM and the Second record to be PM

So something like Iif [Duration], "All Day" run procedure
Else Iif do nothing.

Does that make sense?

 

[jdraw]

What exactly do you mean by "duplicate record"?
What do you plan on doing with Duration?

 

[guinness]

Hi JDRAW

Litteraly create an exact duplicate of the record that I have created so that I now have two records. One starting AM and one PM.

The duration says whether a person is on an activity for a full day, a morning or an afternoon which I need to know in order to schedule free time.

Hope that makes sense