Hi,
I am very new to vba.
I have a form connected to a table with many records.
For each record I would like to print out all the fields which hold values other than the defaultValue.
I have written a code that sets the field height to 0 when the value is the defaultValue.
However, this only works for the first record in the form.
I know this is known problem with continuous forms but I was wondering if anyone could give me a snippet of the appropriate code to overcome it.
I thought of something like a loop that opens the forms - goes to a record - runs the module - prints the form - closes the forms - runs again for the next record.
Thanks in advance
EJ
I am very new to vba.
I have a form connected to a table with many records.
For each record I would like to print out all the fields which hold values other than the defaultValue.
I have written a code that sets the field height to 0 when the value is the defaultValue.
However, this only works for the first record in the form.
I know this is known problem with continuous forms but I was wondering if anyone could give me a snippet of the appropriate code to overcome it.
I thought of something like a loop that opens the forms - goes to a record - runs the module - prints the form - closes the forms - runs again for the next record.
Thanks in advance
EJ