vb/access code

[blockers]

lo all.

Have to do some access programming for computing. In Access i want to click on a record button (e.g. to take me to previous records)

I want some code that checks that all the box in the form have data in.

Can anyone help me with this?

I though something along the lines of:
if "customer" = null then msgbox"you missed some data! - in customer"

*customer being the field.

Thanks all
Will

[Shad]

Set the fields to not allow for null entries and Access will prompt you.

[streetster]

well. i havent tried it, but i would've thought something like...

OnLostFocus of the particular field (or make it run on the command button?)

if customer.caption = ""
then msgbox"you missed out some information"
customer.getfocus

well something like that? go fiddle

mark


edit : or shads way would work too.. arg, always choosing the hard route..

[blockers]

Its just that for teh gay computing A2 project (that this is) we have to use lots of programming to get good marks. (Me and streetster prolly will be posting lots and lots in the near future )

Anyway, i want to look like i know what i am doing with vb so thought i coudl program it to check at the end and look more impressive.

Will

(ty for the help btw)