Filter Fields for Blanks

[Guest]

Hello,

Is there a way to delete a partially filled record using VB code. What
happens is a user will fill in a couple of fields then move to a different
record. The problem with this is if they don't enter data into the Name
field, then I can't tell who the data belongs to.

I need a way to make sure all of four fields are filled with data and if
they are not then delete the partially filled record from the table.

For example, I have these fields:

cboEmp_Name ( Control Source = Employees_ID )
cboTitle ( Control Source = Managers_ID )
cboDept ( Control Source = Departments_ID )
txtNotes ( Control Source = Notes)

Any help at all with this will be greatly appreciated!

-A

 

[Rick B]

If it were me, I'd put in code to prevent them from moving to another record
unless all the required fields were completed.

As far as cleaning up what is already there, just create a delete query to
remove records where there is not data in the desired fields. Of course,
make a backup first.

 

[Guest]

Rick,

I figured out how to delete the partially filled record, but having trouble
checking for blank fields.

Is there a way to check all the listed fields at once, or do I have to write
code for each fields property individually. Right now it looks like each
fields "On Exit" property has to be checked for blanks.

Anyone care to jump in on this?

-A