Subform not showing when parent/child link designated.

[LisaEnns]

ARGGG!!!! Things were working! And now they aren't!! Driving me CRAZY!!

I'm having 3 problems with subforms. One I've actually figured out, but in trying to fix it, the subform disappears



First off, I was having issues with my Sales Products subform not saving the main form's ID to the subform and thus not showing the corresponding data for that main record. I figured out that is was because the parent/child link was removed for some reason, but when I added it, it then makes the subform disappear, and I get an error message saying "The expression you typed is incorrect or too complicated to be evaluated". So that is actually 2 problems in one.

The other problem is with my DiaperParts subform, that also isn't saving the main form's ID, but also the cascading combo boxes were working, but now they aren't.

I used to have a head for all this stuff, but I've still got lingering baby brain, and repeated late nights trying to figure this stuff out so when I try to read some answers with a tonne of technical mumbo jumbo I go all crosseyed and I have no idea what's being said. I just started using access, but do have a basic knowledge of databases. I basically need you to spell it out for me. A lot of the code I've been using I copied from the Goods template, as I'm basing my database on that, but can't use the actual template because everytime I try to customize it I mess something up :P So I thought I'd build one from scratch that was a little less complicated.

https://docs.google.com/file/d/0Bx54...it?usp=sharing

[rpeare]

if you can convert it to 2007 or earlier I can take a look

[LisaEnns]

I can't convert it to earlier version because of the stuff used in it, but it says it's saved in the 2007-2013 compatible format. I did take out a bunch of it, but it's still to big to zip and attach (it's only 5MB unzipped), so that's why it's uploaded to Google Drive. I just uploaded the unzipped version.

[rpeare]

you must be using calculated fields or multi-value fields on your tables. I can't open it without a conversion, sorry.