Hi,

I've put together a db application in Access 2003. The data input form I have put together uses the standard Access negotiation buttons at the bottom of the form to move through the records and create a new entry. The table captures impacts recorded against pieces of work which are stored in 3 other tables. Therefore I have 3 dropdown boxes on the form which are populated by the primary keys of the 3 related tables. What I would like to do is create a piece of code which disables 2 of the drop down boxes whenever a value is entered into any one of the 3. In onter word prevent users from entering a value into more than 1 of the 3 column in the maini table. I have tried using snippets of code that I have found online but have not had very much joy. Any help is appreciated.

---

Answer from Richard Rost:

You need to put an AfterUpdate event in all three of your combo boxes which sets the other combo boxes to be disabled:

ComboBox2.enabled = FALSE
ComboBox3.enabled = FALSE

Then in the OnCurrent event (which runs when you move to a new record) you will need to RE-enable all three of them.

Here's a tutorial which will teach you more about the AfterUpdate event:

You can use an AfterUpdate or BeforeUpdate event to set values, change properties, run macros, and do lots of other cool things.

The major difference between the two is that BeforeUpdate runs BEFORE the data is saved to the table, which allows you to CANCEL the update if the data is not valid. AfterUpdate runs after the data is saved to the table.

Please see the following FREE video tutorial on my web site for step-by-step instructions on how to create an AfterUpdate event:

http://599cd.com/tips/access/afterupdate-event-vba?key=BlFAlEx