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...
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...