Search results

thanks!!!! that works but still have the following problem! consider Equipment 00-053 is unavailable... when i did what you asked the E_ID 00-053 is not in the list. but if i enter it manually using keyboard, it accepts the value.... is there any way that only a value in the list could be...

i am having trouble understanding what you said!!!!! anyway, E_ID field in check out form is a list-box which displays E_ID of all records in equipment table!!!

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...

No.. the record source is a completely different query... i already have a macro for the on click event of the check out button which saves the record and closes the checkout form

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???????????