John,
Thanks for your guidance. However, I think I have not properly explained what I wanted to accomplish. I am trying to explaining the problem in a better way.
My main form is a continuous form called F_EquipmentSpecs. On my main form, I have command buttons to open the related tables/forms and enter data.
When I enter a new data in the main form and create a new equipment record, I update the equipment ID in all the remaining tables to automate the process.
One of the related form is "F_Equipment History". Initially, when I create the new equipment, the equipment History table gets new record added with equipment ID number but other fields such as Failure description etc. are blank.
Some equipment have no failures till date and hence the Failure description field in Equipment History table is null but due to my click action on main form, has a single recordset in equipment history table. What I desire is that when the main form opens and I navigate to different equipment records, if the "Failure description" field is null or blank in Equipment History, the command button on the main "F_Equipment Specification" form to appear greyed and when clicked, it will display message "No Failure History available for this equipment" and when failure description field in related "Equipment History" table is not null or blank, the command button will appear normal.
I need help to achieve the desired visual indication. Thanks in advance.
Posted by: access_kri@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar