My subform is in datasheet view. It has 3 items, ProductID, Quantity, ProductPrice If I want to enter a new product, I start to enter the name and if it does not recognize it, it brings up a message Yes/No to enter new item. I hit yes It opens the :help: form FrmAddNewProduct, I enter all info. I Requery then close. It takes me back to the form I was in with the cursor blinking. I hit enter and brings up the Message again. If I hit No, it will enter the data?? How can I avoid this? If I need to I will send the form so anyone could help! Thank You, Michael

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Datasheet view

Thread starter daniels012
Start date Jan 13, 2005

daniels012

Well-known Member

Jan 13, 2005

My subform is in datasheet view.
It has 3 items, ProductID, Quantity, ProductPrice
If I want to enter a new product, I start to enter the name and if it does not recognize it, it brings up a message Yes/No to enter new item. I hit yes
It opens the

form FrmAddNewProduct, I enter all info.
I Requery then close.
It takes me back to the form I was in with the cursor blinking.
I hit enter and brings up the Message again. If I hit No, it will enter the data??
How can I avoid this? If I need to I will send the form so anyone could help!

Thank You,
Michael