Trying to write a simplet vba code

[bopsgtir]

Hi all im trying to write a code based on a form control.



what im after is if stage_code_complete is left blank ie you enter the cell but dont enter any information the code will not run

but if you enter data which is a combobox then you will be tabbed to control nrd_finding and you must enter a reason, if you try to exit then a msgbox stating information required.

Any help would be great

[RuralGuy]

Have you put your code in the stage_code_complete control AfterUpdate event?

[bopsgtir]

Sorry Ruralguy, i probable explained wrong i havent wrote a code, i want to learn to write a code which does the above, i know what i want it to do, im just not sure do to do it, if theres any sites that could give me the help im happy to read up on it, just trying to get a point in the right direction

[RuralGuy]

I think Crystal's site is a good place to start.
http://www.accessmvp.com/strive4peace/
Can I delete the other thread?

[bopsgtir]

yes please.

[bopsgtir]

im still not getting the hang of this, can anyone help me write the code.

i want an afterupdate if (stage code complete) is not null to then go to control (nrd finding) and force user to select something from the combobox

Please help anyone many thanks

[orange]

You might want to show us what you have and what you have tried.
If you post your database, please use an mdb.

This free video tutorial,or others at Datapig, may be helpful
http://www.datapigtechnologies.com/f...econtrols.html