You must enter a value in the "" field (1 Viewer)

[jleval]

Hello All,

Okay, I am having the strangest issue. I have a form that allows the user to click a button and add a new record. When you add a new record, certain default values are input except for two, PartNumber and PartDescripton.

After you enter a part number and a part description and attempt to save the record, this error pops up. I know for a fact that I am entering a value.

Why does access do stuff like this!!:banghead:

Does anybody have a fix to this bug

ps I tried putting default values in both the form and the underlying table, it just states that duplicate values are being created..

Thanks any help is appreciated

 

[dylan_dog]

Maybe this will help you:

http://windowssecrets.com/forums/sh...st-enter-a-value-in-the-Field-Name-field-quot

 

[jleval]

Okay, I found the problem but need a work around. In the parent form i have a subform that relies on the partnumber field to show the values of that subform. It is in the underlying query.

What happens is the partNumber somehow ends up being null whenever you add a new record. How can I make that main form place the partNumer in the subform after I update the field?

 

[Karl427]

Hello

I know it's some time ago but did you ever find a workaround for the blank parent field?

Regards