Form Visible

[Brook]

I am trying to create a form that is only visible it a
certain criteria is met.

My criteria is that a column "Notes" is not Null.

So if my Notes column contains data then my frmNotes will
appear otherwise it will not appear.

thanks,

brook

 

[Lynn Trapp]

Brook,
Unitl you enter data in your table, your Notes column will be null. So, How
do you plan to ever make the form visible if you haven't yet entered a
value in the Notes column? You may want to rethink that idea.

 

[Brook]

The Table that houses my notes is a table that will be
updated on a weekly basis depending on the notes or
special notices for a particular company. That is how that
table will be populated. In the initial state, 10 out of
our 100 companies will have a Special Note that is why I
am trying to perform the Form.visible function.

Please let me know if you have any questions

Brook

 

[Lynn Trapp]

Is the form you want to make visible or invisible actually a subform on a
main form for each company?

 

[Brook]

No,

This is actually what happens:

The user enters the database and clicks a button called
Company Sales. Which has a limited amount of information,
company ID, Company Name, Total Sales.

Then there is another button the user can click to go to
Company Details, when the user clicks this company Details
button is when I want the "pop-up" form to come up. the
Company Details button goes to a form that contains more
information about the company: Sales Staff, Address,
Shipping, etc. And the pop-up form that I want will be
based on the special notes table, which will compare the
Company Details Form to the tblSpecialNotes. HOpe this is
clear.

Brook