Search results

I want to create a validation rule for a field [E_ID] in the form [Check Out] so that when the field is updated, the field should contain only the values of the records which have another field [Status] as "Available" in another query [Equipments Query]????? I tried the following, but it says...

i want to create an update query based on the following conditions. when the [Check Out] button in the form [Check Out] is clicked the update query should update the field [Status] in the query [Equipments Query] to "Unavailable"!!!! when the [Check In] button in the form [Check In] is...

Can anyone teach me how to write an expression in expression builder so that when I click the [Check Out] button in the Check Out form, a field [Status] in the query is changed to available???????????