|
View Full Version : Check to see if form is blank? GregSmith 05-14-2002, 10:29 AM How can I check to see if something has been added to a form? When you open a form and enter in no entries, it's considered blank till you select an option from a drop down box or enter text in a field. Is this correct? DBL 05-14-2002, 01:46 PM I use the autonumber field to assess whether the record has been created or not. As soon as you make an entry, the autonumber is assigned, before that it's a clean entry: If IsNull (Me.AutnoNoField) or Me.AutnoNoField = 0 Then.... HTH Elana 05-14-2002, 02:05 PM Or, you can use If Me.NewRecord = True then... Rich 05-14-2002, 02:09 PM If Me.NewRecord Then will fire as soon as the form moves to a new record even if no fields are filled or selected. You don't need =True either. |