V
vtj
I have a subform that gets filled by a query based upon a dropdown box value
in the form. After the query runs, some fields can be updated and the update
information gets written back to the table that the query uses to fill what
information it has available. They are bound fields and the source is the
query so that empty fields can be updated in the table. After the query
runs, I would like one of the fields to get the contents of a textbox on
another form, not the main form for the subform but a form that is open at
the time. I have tried using "=[Forms]![Main Menu]![Text13]" which is where
the information resides that I want in the subform field. I have placed it
in default, on enter, on got focus, etc. and none of them seem to work. The
default works when the form is opened but the field is empty after the query
runs. I can use the date picker and fill the field and it will update to the
table but would like it to automatically get the date from Text13. I am
obviously missing some basic piece of information (knowledge). This is for
Access 2007. Maybe you could point me in the right direction? Thanks.
in the form. After the query runs, some fields can be updated and the update
information gets written back to the table that the query uses to fill what
information it has available. They are bound fields and the source is the
query so that empty fields can be updated in the table. After the query
runs, I would like one of the fields to get the contents of a textbox on
another form, not the main form for the subform but a form that is open at
the time. I have tried using "=[Forms]![Main Menu]![Text13]" which is where
the information resides that I want in the subform field. I have placed it
in default, on enter, on got focus, etc. and none of them seem to work. The
default works when the form is opened but the field is empty after the query
runs. I can use the date picker and fill the field and it will update to the
table but would like it to automatically get the date from Text13. I am
obviously missing some basic piece of information (knowledge). This is for
Access 2007. Maybe you could point me in the right direction? Thanks.