Find record or on not in list, add record

[cabbey77]

The above is exactly what I want to do.

If the part number exists, I want it to pull up the record (I am successfully using an unbound text box for this), but if the part number does not exist, I want it to go to a New Record, and it just refuses to do that.

Any ideas?

 

[missinglinq]

How are you trying to accomplish going to a new record, cabbey?

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[cabbey77]

I have attempted to use the Not In List function and the DoCmd.GoToRecord....

 

[missinglinq]

If the part number exists, I want it to pull up the record (I am successfully using an unbound text box for this), but if the part number does not exist, I want it to go to a New Record, and it just refuses to do that.

"How are you trying to accomplish going to a new record... "

I have attempted to use the Not In List function

If you're using an unbound textbox, how do use the Not In List function? To the best of my knowledge, only comboboes have this property.

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

How are ya cabbey . . .

I agree with [blue]missinglinq[/blue] only [blue]is this a bound form with an unbound textbox or is the form unbound period? . . .[/blue]

[blue]You can't goto a new record in an unbound form![/blue]

See Ya! . . . . . .

 

[cabbey77]

My bad, it is an unbound combo box, and no, then entire form is not unbound. But I did figure out a way to get this to work. I have created a pre-form that is nothing but the combobox, the not in list function works fine from here and opens the original form either in add or edit mode, depending on whether or not the item is in list.