how to go to next record with blank field?

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
 
G

Guest

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.
 
L

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.

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
 
L

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top