Combo Box changing data in Table ?

[Buford]

I am using a Combo Box on one form to select records from a table to display
on the next form. I do not want to update the data, only use the record
selected in the Combo Box for the Criteria in a Query. Currently, when I
select the record I want in the Combo Box it brings up the next form
correctly. However, when I go into the table linked to the Combo Box, the
default record showing initially in the drop down of the Combo Box is being
changed to the record I end up selecting in the Combo Box. I think I have
narrowed it down to the problem with the first form. I am not familiar with
code so I need help that I can implement using the Properties boxes or macros
or something along those lines versus code-writing.

What I have is the first form is called frm-ViewMODs which only has a Combo
Box linked to the Table called 1tblMod to select ModNum. I used an After
Update Event to run a Macro (macro-ModView) to Open the second form
(frm-ModSLIN-Output)in Read Only Mode which is based on a Query. The
criteria for the Query is based on the Combo Box called comboModNum. The
Criteria box in the Query for the field ModNum is
[Forms]![frm-ViewMODs]![comboModNum].

I have tried everything I can find to handle this through Read Only
properties and have not found the right combination. I also tried to change
the first form from using an After Update Event to On Change to see if that
helped which it did not.

Any help would be appreciated !

 

[Douglas J. Steele]

Sounds as though you may have bound your combo box to a field in the form's
recordset.

Look at the Properties window for the combo box. Make sure there's nothing
in the ControlSource property.

 

[Buford]

Douglas - I appreciate the help. Removing the information in the
ControlSource property was the key it seemed. Thanks again !

Buford

Sounds as though you may have bound your combo box to a field in the form's
recordset.

Look at the Properties window for the combo box. Make sure there's nothing
in the ControlSource property.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am using a Combo Box on one form to select records from a table to
display
on the next form. I do not want to update the data, only use the record
selected in the Combo Box for the Criteria in a Query. Currently, when I
select the record I want in the Combo Box it brings up the next form
correctly. However, when I go into the table linked to the Combo Box, the
default record showing initially in the drop down of the Combo Box is
being
changed to the record I end up selecting in the Combo Box. I think I have
narrowed it down to the problem with the first form. I am not familiar
with
code so I need help that I can implement using the Properties boxes or
macros
or something along those lines versus code-writing.

What I have is the first form is called frm-ViewMODs which only has a
Combo
Box linked to the Table called 1tblMod to select ModNum. I used an After
Update Event to run a Macro (macro-ModView) to Open the second form
(frm-ModSLIN-Output)in Read Only Mode which is based on a Query. The
criteria for the Query is based on the Combo Box called comboModNum. The
Criteria box in the Query for the field ModNum is
[Forms]![frm-ViewMODs]![comboModNum].

I have tried everything I can find to handle this through Read Only
properties and have not found the right combination. I also tried to
change
the first form from using an After Update Event to On Change to see if
that
helped which it did not.

Any help would be appreciated !