Ok, I'm back

[Hope]

Here is a question: thought I was done,but thats never the case.

When I click on a part number in my drop down box and hit enter, it disappears, but if I click on a part number in the drop down and click in the next field it stays..any thoughts there?

 

[mdschuetz]

What events are running under the control?

 

[Hope]

ok

the control is my combo box

 

[mdschuetz]

What, if any event procedures are running under your combo box?
Where is your combo box getting its information? Is it bound to a table, a query, or is it unbound?

 

[Hope]

sorry I did write it was linked to event prod but must not of sent, and it is bound to a query telling it to pull the parts in numeric order and it has this event procedure linked to it
Private Sub Test_Part_BeforeUpdate(Cancel As Integer)
Dim strPart As String

strPart = Me.Test_Part.Value
If DCount("[Part_Num]", "tblPart", "[Part_Num] = '" & strPart & "'") = 0 Then
Cancel = True
End If

End Sub

 

[mdschuetz]

Can you post a sample of your DB, as long as its not 2007 I can look at it.

 

[mdschuetz]

Set your tab index properly.

Be sure to start at 0 with the initial control and increase by 1 with your control flow down the form.

 

[Hope]

That corrected it, thank you so much for your help