M
MicrosoftRocks
I am using Microsoft Access 97.
I have a linked table to a SQL server database. I set up a form that has
combo boxes that are populated from some tables in Access. Whenever I update
one of the combo boxes to null (cmbBox = Null) all the combo boxes on the
form are set to null. This only happens when the form is based on the table
that is linked to a SQL server database. This does not happen when the form
is based on an Access table. Any ideas how I can work around this? I would
like to be able to set the combo box to null, because I have queries that are
based on null fields. Thanks for your help!
I have a linked table to a SQL server database. I set up a form that has
combo boxes that are populated from some tables in Access. Whenever I update
one of the combo boxes to null (cmbBox = Null) all the combo boxes on the
form are set to null. This only happens when the form is based on the table
that is linked to a SQL server database. This does not happen when the form
is based on an Access table. Any ideas how I can work around this? I would
like to be able to set the combo box to null, because I have queries that are
based on null fields. Thanks for your help!