Okay, to some this is so easy, but i am stumped. sorry wrox book is not working for me. ex-cobol programmer learning vb.
I have a form with data, I need to search that form for field called weight# ( i used a the wizard and it works), but if it is not found, I need to open a new form in add mode, if found open that form in edit.

anyone can help me...............
thannks

sj

Set the combo box Limit To List property to NO.

Then set the combo box On Not In List event to open the form in edit mode on a new record.

See the Microsoft MSDN web site for further details. Do a search for Access On Not In List.

HTH


mmcdonal