Command button on form

[KLR]

I have created a tabular form and have added a command button that is
linked to the the 'Report ID' field. Clicking this button takes the
user to a form for completing a detailed account visit report.

My problem is that my tabular form contains a list of all account
visits - past and upcoming. Therefore some reports will have already
been created, some will be waiting to be created.

How can I have the command button appear only next to those account
visit records which haven't been completed? I have a 'Date report
completed' field on the form which I think can be used for this
purpose. But I am not sure how to go about it.

 

[Eric D via AccessMonster.com]

What is your "form for completing a detailed account visit report" based on?
If the form is based on a query, simply add "is null" to the Date report
completed as the criteria.
With no other changes, your query should list all records for the Report ID
where the Date report completed is blank.

 

[Guest]

Hi

U can use DLookup to check if there is any report for that ID and based on
the result to have make button visible or hide. In DLookup u can use count()
method to check if there is any child record exits for this ID. The simple
IF.. Else would do ur work.

RMA