Selecting Combo box item based on Text box

[Chuckd]

Here is my delema I have a text box called "Finish Date" and a combo box called "Status". What I want to do is when I put a date in "Finish Date" it selects the line item in "Status" called "Complete". Nothing I've tried yet has worked. Please help

 

[maxmangion]

try this in the afterupadte event of your finish date:

If Not IsNull(Me.FinishDate) Then
Me.Status = "Complete"
End If

 

[Mile-O]

Since your status field is reliant upon there being a finish date in your table it renders any status field you have in the table redundant.

You can replace the combobox with a textbox. Disable and lock the textbox and set its ControlSource as:
=IIf(IsNull(Me.FinishDate), "Incomplete", "Complete")