Expression in Query Locks combo box in Form

[MichelleP]

I need some advise. I have a database that tracks the calibration of test equipment. I enter in the frequency of the calibration (ex: annual, monthly, etc.) and then the date it was last calibrated. Through code the Due Date is automatically generated based on the frequency; this portion works fine.

Recently I was asked to add a Send by date. This would be based on frequency and give a lead time for when we should send the equipment out. However it didn't work. I used exactly the same code that works for the Due Date field, just changing the field name, without success. So I decided to come at this from a different angle.

I went into the query the form is sourced too and removed the "Send by" field. I then created an expression field: Send_by: IIf([Frequency]="Annual-6 week lead",[Due_Date]-45,[Due_Date]-30)

This gave me the date I needed, however I can no longer change the frequency. The frequency was a drop down combo box. I know the expression refers to what is selected in the frequency field, but why would it lock the field in the form and is there anything I can do? Any help would be appreciated!

 

[missinglinq]

Can you enter data into any other Control on the Form? Not being able to make a selection from a Combobox usually occurs when the Form itsef is Read-Only/Non-editable...and I wonder if you've done something to cause this to happen.

Linq ;0)>

 

[MichelleP]

I didn't even realize but the whole form locked. However I did not make it read only. The only steps I took were the ones I posted. I only removed one field and then inserted an expression with the same field name, how could that lock the whole form? Any ideas?