On Wed, 19 May 2010 19:51:01 -0700, Chiki
wrote:

Yes, i had tried using the formula u had given.

Its returning an #Error Message.I dont know why.I think i had to check out
the exact syntax or check the correct text box names.

Thanks.

Well... yes.

I cannot see your screen. I do not know the name of your table; you should use
it in place of "tablename". Likewise you need to specify the correct
fieldnames... which, again, I do not know.

If you'll post some more details about your table (table name, fieldnames,
datatypes of those fields, form control names) someone should be able to help.
--

John W. Vinson [MVP]