Error Messages On Subforms, Access 2016

[davegri]

Also, I may do the same show year after year and would like for the payment information to show up from year to year too. Does that make sense?

Would you add a new record to tblCraftShow for a recurring show, or use the old record? Currently the Fee is stored in tblCraftShow. If you want to reuse the record year to year, you would need to move the Fee to tblPaymentMethod. That would allow you to keep track if the fee changed from year to year.

[davegri]

yes, and yes.

OK, post the db.
What are the allowable values for the combobox dropdowns on the new subform?

[roxdrob]

Hi, I got through that issue, but am having another. I moved the Fee to the payment table as well as an earnings field. In my form, earnings is working, but fee is not. I've compared them in the properties and they appear the same. I'm attaching the file.

CraftShowsV22.zip

[davegri]

See if this looks any better.
CraftShowsV23.zip

[roxdrob]

Thanks so much!