It means that your textbox is UNBOUND.
In that case I put textbox in the FORM FOOTER.
Look at "DemoSubDateA2002.mdb" (attachment zip).
Combo box "f1id2" in "frmSubform", and a textbox in
the form footer "f2Name" (Text4 field).
Open "frmMain" and try.
Hello, I cannot open the ZIP file, message says it is corrupted. I had the same problem a few weeks back when I tried uploading a database inside a zip file. Any chance you could upload it somewhere else or try again?
The textbox on my form, is bound to a field in a table by the way.
All I want to do is display the last value of a field of a table from my subform (set to continuous form) in a textbox on the mainform.
The records in the subform have a primary key field (e.g. 001, 002, 003) etc , so it is field 'FieldName3' from the last record (called say '003') which I want to display in the textbox on the main form.
When a new record is added (called say record '4') the textbox on the main form will display the last record from FieldName3 still, but this time it will be for record number '4' and so on..
I want to take from my subform, the last record of a particular field, and then display that last record in a textbox on my main form.
I have uploaded a database here, just load the form called 'frmItems'.
The subform called 'frmItemLocations' has a field called 'LocationName', the location is Location4 for the first record. I want 'Location4' to be displayed in the textbox called 'txtLocatons' at the top of the the master from called 'frmItems'.
Then when you switch to the next record (there are only 2) the last location name is 'location2', so then I would like location2 to be displayed in the textbox.