Can I disable a pop up message?

[Kcweir]

I have a data entry form that has a problem I can't figure out. When I open the form frmVendorsCategories I get a message that states "The value you entered isn't valid for this field". I'm sure the field is one in the subform, but can't see where the problem lies.

If I ignore the message and continue to enter on the form, it works fine. All entries are reflected correctly in tblVendorsCategories. Can I disable this message to allow for data entry from my form?

I'm attaching a copy of the database to this post. If anyone has any ideas about why the error pops up, or how to disable the message, please let me know.

Regards,
Kimberly

 

[Mile-O]

It means you are trying to put a value into the table that it can't hold. You'll get that message if you try to put text into a numerical field.

Have a look at your table design and check if the field you are having the problem with is of the data type you are trying to enter.

 

[Kcweir]

I thought that, but all the values are either numbers or autonumbers. How is it possible for the data not to be the right type?

Kimberly

 

[SforSoftware]

Kimberly,

I had a look at your database.

The problem is the DLookUp in the Form_Current Procedure, that tries to set a text-value in the numeric field.

I figured out that you didn't set a controlsource for your comboboxes (Category and SubCategory). Set this controlsources to the right field (...ID) and you can delete all your code in the form and the both other (hidden) textboxes.

When you do that, everything go allright I'd think.

I attached the new, corrected database.

 

[Kcweir]

MY HERO! Thank you thank you thank you thank you.

Also thank you to WayneRyan and yippie-ky-yay for their help along the way. This forum saved me, and I think will make me look good to the boss too!

Kimberly

 

[SforSoftware]

I was glad to help you...

Greetz (to your boss )
Bert