Current Record in Visual Basic....

[Daniel]

Okay, I have a database which offers user to add suggestions to the
database.

If a new suggestion is added, it check a box within the table marked
"activesuggestion" - is it possible to write some sort of code that only
shows the label and text box in my form (label says "new suggestions" and
text box had the total number of new suggestions in it) when a new
suggestion has been added.

What I want is, if there are no new suggestions or "activesuggestions"
checked within the table, then the label and text box to be hidden, but when
a new suggestion is added, for them both to appear.

The table of suggestions will be on going and when a command button is
clicked to show the suggestion has been actioned, the "activesuggestions"
box is unchecked as it is no longer active.

Hope all this makes sense... thanks in advance

Daniel

 

[David Lloyd]

Daniel:

I'm not sure I completely understand what you are trying to accomplish here,
however, here is a suggestion.

txtMyTextbox.Visible= (DCount("MyBooleanFieldName","MyTableName",
"MyBooleanFieldName=True") >0)
lblMyLabelName.Visible=txtMyTextbox.Visible

HTH,

David Lloyd
Lemington Consulting
http://lemingtonit.com

 

[Daniel]

David

That did the trick - thank you for your time

Daniel