Do Not Run a Code if Text is not Autofilled.

[zashaikh]

Sorry. Entire event code is below:

Private Sub cmbFoodInvolved_AfterUpdate(Cancel As Integer)

If IsNull(DLookup("Food Involved", "tblProductAutofill", "Food Involved = '" & Me!cmbFoodInvolved.Text & "'")) Then 
Me.txtIngredient.SetFocus

Else
Me.txtIngredient.Value = Me.cmbFoodInvolved.Column(1)
Me.txtCategory.Value = Me.cmbFoodInvolved.Column(2)
Me.txtCharaceteristics.Value = Me.cmbFoodInvolved.Column(3)
Me.txtDescription.Value = Me.cmbFoodInvolved.Column(4)
Me.txtQuantity.SetFocus
End If
End Sub

[Micron]

Interesting that the code in the email is not the same as what's posted here. The email code definitely has something about it that could cause your error, but this forum doesn't indicate that you went back to edit it. So I see nothing obviously wrong, but you're not indicating how this code was placed into your form module after I wrote about how to do it. For all I know, cmbFoodInvolved is not really the name of your control, which my instructions would have eliminated the opening line as a potential problem. So you will have to compact and zip your db and post it here for me to help any further.

[zashaikh]

What are you referring to when you say "emai lcode"

And you are right. I am not allowed to show the actual database. (At least I could possibly get into trouble.) As such, I have been using different names. I will see what more I can do. I do appreciate all of your help and time however.

[Micron]

I'm afraid I permanently deleted the forum notification email. It had something like
Me.txtIngredient.SetFocusElse
Else

If you cannot mock up a sample by removing all the unnecessary tables, queries, reports, private info etc. then I don't know what else I can do. It sounds like maybe we're not even using the correct names for controls involved in the procedure.
Good luck.