Re: [MS_AccessPros] Command button greyed if no entry in related form/table

 

I don't understand.  What is the design of your tables?  Which table is being edited by F_EquipmentSpecs?  Why are you automatically adding rows to other tables when a new row is created in F_EquipmentSpecs?  If there should be no matching data, why create "null" rows?

Also, please include the entire message string when replying.  If you're replying on the web, be sure to click Show message history in the Reply box.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Mar 31, 2017, at 7:21 PM, access_kri@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___