how to go to next record with blank field?

  • Thread starter Thread starter ljb
  • Start date Start date
L

ljb

I need form button code that will take me to the next record that has a
blank 'description' field. My underlying table has a field named 'file' and
one named 'description'. I'm trying to fill in any blank descriptions.
Filter isn't satisfactory because I need to be able to see adjacent records
to help get the correct context. Database is Access 2000.

thanks
LJB
 
write a query based on the table. in the criteria pane of
the description enter Is Null. It will show you all the
records in the table whose description is blank.
 
write a query based on the table. in the criteria pane of
the description enter Is Null. It will show you all the
records in the table whose description is blank.
Click to expand...

Yes it will show all blank descriptions but it doesn't show adjacent records
that are not blank.

This is a database of several years vacation photos. To enable me to
identify the location I need to see adjacent records that may have
descriptions. Mixed in 5000+ records are about 300 without descriptions. I
need to be able to easily get to them. My form has navigation buttons, a
picture box that shows the current record's picture and a description text
box. Now I need button code to quickly jump me to the next record that has a
blank field. I think DoCmd.FindRecord and perhaps FindNext can be made to do
that but I stumped.

LJB
 
ljb said:
This is a database of several years vacation photos. To enable me to
identify the location I need to see adjacent records that may have
descriptions. Mixed in 5000+ records are about 300 without descriptions. I
need to be able to easily get to them. My form has navigation buttons, a
picture box that shows the current record's picture and a description text
box. Now I need button code to quickly jump me to the next record that has a
blank field. I think DoCmd.FindRecord and perhaps FindNext can be made to do
that but I stumped.

LJB
Click to expand...

I found the solution. A button with the following does what I need.
DoCmd.FindRecord "is null", acEntire, False, acDown, False, acCurrent, False

I think my problem may have been that my description field wasn't the
current field when I was testing this.
 
Back
Top