J
jhunter
=====
ISSUE
=====
I get this message *****SOMETIMES*****...
Field 'Table.Field1' cannot be a zero-length string.
=======================
WHEN I GET THIS MESSAGE
=======================
I have entered something in Field1 in the **PREVIOUS** record of a
continuous form (and ONLY when I try to go from the CURRENT **RECORD**
to a another record).
=============================
WHEN I do no GET THIS MESSAGE
=============================
If I've never entered anything in Field1. I can add as many records as
I want and never have a problem.
=====
NOTES
=====
1)Field1 is NOT set to required in the Table or Form properties.
2)I do use an AFTER UPDATE event for Field1 that does the following...
Me!Field1.DefaultValue = "'" & Me!Field1& "'"
3)There are no other events.
==========
BACKGROUND
==========
O/S = Win2k Pro
Patches Installed
Software = Access 2000
Patches Installed
=========
Thanks!!!
THE END
=========
ISSUE
=====
I get this message *****SOMETIMES*****...
Field 'Table.Field1' cannot be a zero-length string.
=======================
WHEN I GET THIS MESSAGE
=======================
I have entered something in Field1 in the **PREVIOUS** record of a
continuous form (and ONLY when I try to go from the CURRENT **RECORD**
to a another record).
=============================
WHEN I do no GET THIS MESSAGE
=============================
If I've never entered anything in Field1. I can add as many records as
I want and never have a problem.
=====
NOTES
=====
1)Field1 is NOT set to required in the Table or Form properties.
2)I do use an AFTER UPDATE event for Field1 that does the following...
Me!Field1.DefaultValue = "'" & Me!Field1& "'"
3)There are no other events.
==========
BACKGROUND
==========
O/S = Win2k Pro
Patches Installed
Software = Access 2000
Patches Installed
=========
Thanks!!!
THE END
=========