Dear All,
I am trying to put together a small homemade accounting database and
have encountered the following problems, hope you guys can help:
1) I have a subform which includes 3 columns- vochure number (more like
parent record number), credit field and debit field. My objective is to
create a warning box and lock user within the subform if the total sum
of the credit doesn't equal to the total sum of the debit field within
that master record. I would like to know if anyone can give me a small
piece of sample code.
2) I also have a date field within the parent form. I want to change
the date field within the subform equal to the parent field "on
active". However, when I place the code there, which looks something
like...
me.subform.form.datefield.value = ddate (ddate is a public storage
variable)
the datefield would give me a time value, let say 12:03AM instead of a
date value. Does anyone know why?
Thanks for your help,
Tom