Add record HELP

[ian_ok]

I have a form which details are added on, on completion you click a macro to return to main menu. Yet if not all fields are completed it causes a macro error (as you would expect) my problem is that the fields that are left blank are option boxes (I know they need to be completed yet it could be missed just by mistake and I need to take this into account).

How do I ensure that they are completed before you try to exit via the macro.

Thank you.

Ian

 

[Rich]

Add validation rules to your macro, once your macro is working properly convert it to vba. Look for help on Validate Data by Using a Macro.
HTH

 

[rhay]

How do you convert Macros to Code?

Robert

 

[Rich]

Right click , convert to module , be warned though some references are not converted as efficiently as writing directlt in vba.

 

[ian_ok]

I do keep track of all my posts, but don't for one reason and another manage to get round to completing the task.....So......

I need to know where abouts do you right click to convert a macro to code, I've tried all sorts to no avail...I'm running Access97.

Ian

 

[charityg]

On the macro tab (in the database window) right click on the macro and select save as export, then Save as Visual Basic Module.