Kiyimbagrace
Last Activity: Aug 8 '13, 11:52 AM
Joined: Jul 25 '13
Location:
-
Dear ZMBD and Rabbit, Thanx for your time. Your help in this regard is much appreciated. I am still working on this ...glad to know you are helping. -
Thank you both Rabbit and zmbd. kindly note that I am not a guru in writing code. The form "wells" is bound via foreign keys from the "wells" table to the other tables in the database.
I tried using this event procedure below on the 'on update' but when I change or remove values the lock/unlock does not reset:
...Code:Private Sub Combo157_AfterUpdate() If IsNull(Me.Combo157.Value) Then Me.Combo153.Locked
Leave a comment:
-
In my wells' form I have a dropdown...
In my ‘Wells’ Form I have a dropdown on ‘Well purpose’ field with the following entries: Injection, Appraisal, Observation, Production, Wildcat.
I have another dropdown on the ‘prospect’ field with several prospect names which are updated in a separate ‘prospect’ form.
I also have another dropdown on the ‘Discovery’ field with several discovery names which are updated in a separate ‘discovery’...Last edited by zmbd; Jul 25 '13, 06:44 PM. Reason: [z{Replacing original post with the updated information.}{added whitespace and made a minor grammer change due to this.}]
No activity results to display
Leave a comment: