View Full Version : Forms and SubForms and record operations...


Randomblink
09-12-2001, 08:57 AM
Ok...
I have table one...
Location_ID - Autonumber field [relationship]
Various Fields - basic location info

I have table two...
Location_ID - Number field [relationship]
Photo_ID - Individualizes each photo (primary key)
Photo - OLEObject field


Now then...
I have one form for browsing through locations...
I have a subform that holds the photos...
If you get to a location that needs photos entered, you just enter one...
But...If I need to look at all of the photos for one location, it says invalid expression entered in my coding...

On the subform_photo_entry I have the Location_ID default set to the main Form Location_ID, this way whenever I enter a new pic it will automatically be aligned with the correct location...

Can anyone help me with the little I just provided...?

Thanks in advance...

Pat Hartman
09-12-2001, 12:09 PM
You don't need to do that. You should remove the Location_ID from the subform. If the mainform and subform are properly linked, Access will populate the Location_ID as required.