B
Barry Gilbert
I have an unbound form that is used to gather criteria for reports and
to display detail records. Under a button click, I dynamically set the
form's recordsource and the ControlSource properties of several
controls in the detail section. I recently upsized the back-end to SQL
Server and now the form is misbehaving.
When my code reaches the first line that sets a control's
ControlSource, it clears the values from all controls in the FormHeader
section. This is a mystery to me and I cannot see what this could
possibly have to do with the SQL upgrade, especially considering that
the form is unbound at the point that this happens.
Using Access 2000 for the front-end.
Any help would be appreciated.
Barry
to display detail records. Under a button click, I dynamically set the
form's recordsource and the ControlSource properties of several
controls in the detail section. I recently upsized the back-end to SQL
Server and now the form is misbehaving.
When my code reaches the first line that sets a control's
ControlSource, it clears the values from all controls in the FormHeader
section. This is a mystery to me and I cannot see what this could
possibly have to do with the SQL upgrade, especially considering that
the form is unbound at the point that this happens.
Using Access 2000 for the front-end.
Any help would be appreciated.
Barry