How can I get one field in a form to be visible and available for entry only when another field (which is also from another table) has been chosen with a certain value? Thanks.
Advanced Beginner
Windows 10 
Office 365
How can I get one field in a form to be visible and available for entry only when another field (which is also from another table) has been chosen with a certain value? Thanks.
VIP
Windows 10 Access 2010 32bit
Should not be doing data entry to fields of multiple tables in one form, at least that would be unusual situation.
However, use control AfterUpdate event to set other control enabled/disabled.
Me.control2.Enabled = Me.control1 = "this specific value"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Advanced Beginner
Windows 10 Office 365
Thanks. How would I get one field value to trigger the automatic selection of another field in the same form? Thanks again.
Virtually Inert Person
Windows 10 Access 2016
If Me.someField = someValue Then Me.OtherControl.SetFocus
unless by selection you mean something else.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Advanced Beginner
Windows 10 Office 365
I wasn't clear with my question. Each field is a combobox on my form. Where one value is chosen in one combobox, I would like it to automatically choose a value in another combobox on the same record.
VIP
Windows 10 Access 2010 32bit
Well, that's not what you said in OP.
Why? What value do you want to set in combobox?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Virtually Inert Person
Windows 10 Access 2016
If Me.someField = someValue Then Me.OtherControl = anotherValue
Not sure I see the sense in populating combos this way - they might as well be textboxes?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
How to create a field on a form that becomes a hyperlink if condition is true.
Adding Value to a field when condition is met
Multiple "WHERE" condition on form button not recognizing existing field
Posting Permissions
Reply With Quote