jimatqsi: That's not really the whole picture.
I have several unbound forms and controls where'in the control will return a unique value in the details section, I even have one that will calculate the difference between the relative-prior record and the current record (yes that can change in positionals; however that's the desired result - I have another that spans based on PK's and FK's vs date). However, these types of controls are typically very difficult to create
pifpifpoufa:
You have two questions. Please only one per thread.
To get a different value, you will usually need a custom function.
For example, I have database that shows a different photo for each person (this was fun) in a continuous form.
I have a text control with the control source:
=fncPhotoIdLoc([people_photo],"photoid")
The function takes the information from the field [people_photo] and the directory location "photoid" finds the path (in this case realative to the current database location) and returns the full path to that photo.
This same function acts as the control source for my image control too (works in ACC2003 and ACC2010).
The report for this database does the same thing.
These controls are NOT editable
As for your specific need:
rowsource query is based on another column value from the same row. Can it be done simply, and consider the rowsource
Keep in mind that the CONTROL source is NOT the same as the ROW source. You will also have to have a REQUERY in the dependant control to get the ROW source in the dependant to update the available ROW source recordset when the value of the dominate control is changed.
There will be some additional difficulties with your form on loading in the form control values may not be set; thus, resulting in a null/invalid recordset which can cause the form to crash.