Prev: Help with List Rowsource SQL syntax please
Next: Refresh List after edits
From: Buford on 17 Jun 2008 09:00
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 !



From: Douglas J. Steele on 17 Jun 2008 09:10
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
http://I.Am/DougSteele
(no e-mails, please!)


"Buford" <Buford(a)discussions.microsoft.com> wrote in message
news:B625F94D-DFF3-42F3-A6E3-AE6DECFB70ED(a)microsoft.com...
>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 !
>
>
>


From: Buford on 17 Jun 2008 14:40
Douglas - I appreciate the help. Removing the information in the
ControlSource property was the key it seemed. Thanks again !

Buford


"Douglas J. Steele" wrote:

> 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
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Buford" <Buford(a)discussions.microsoft.com> wrote in message
> news:B625F94D-DFF3-42F3-A6E3-AE6DECFB70ED(a)microsoft.com...
> >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 !
> >
> >
> >
>
>
>
 | 
Pages: 1
Prev: Help with List Rowsource SQL syntax please
Next: Refresh List after edits