place holder, blank record, message

  • Thread starter Thread starter BrightIdeas
  • Start date Start date
B

BrightIdeas

When I run a query I want to create a blank record with a message "no
previous record"
without upsetting the primary key field and the underlying database-
ie as a place holder when there are no previous records
 
I am guessing you don't really want to create a blank record in the table -
no way to do so without generating a key value and then your table would be
riddled with these after time goes by.......

Presuming you are looking at the query results via a form or report then you
want to add that message as a label - put have it set as not visible...

Then if the query result has null value - set label property as visible...
 
Back
Top