combo box display result

[bpauley]

I have a combo box on a form that is filtered to one record based on
previous selections on the form.
My question is how to get the one record to display in the combo box
automatically, so the user does not have to click the down arrow and select
the one record.
The combo box name that I want to display the filtered record is:
cboCurrRateAmt
Control Source of the combo box: CurrRateAmt
Field in the tblFacilityRates that I want to display: RateAmt

SQL Row Source:
SELECT tblFacilityRates.RateAmt, tblFacilityRates.FacilityID,
tblFacilityRates.RateTypeID, tblFacilityRates.RateTypeDescription,
tblFacilityRates.RateType
FROM tblFacilityRates
WHERE
(((tblFacilityRates.FacilityID)=[forms]![frmEnterMonthlyVisits].[cbofacilityID])
AND
((tblFacilityRates.RateTypeID)=[forms]![frmEnterMonthlyVisits].[cboRateTypeID])
AND
((tblFacilityRates.RateTypeDescription)=[forms]![frmEnterMonthlyVisits].[txtposition]))
ORDER BY tblFacilityRates.FacilityID, tblFacilityRates.RateTypeID,
tblFacilityRates.RateTypeDescription
WITH OWNERACCESS OPTION;

Thanks for your input.

novice user,
Bill

 

[bpauley]

thank you for the reply.
Where were you suggesting to but your response?
Bill

Try:
Me.cboCurrRateAmt = Me.cboCurrRateAmt.ItemData(0)

I have a combo box on a form that is filtered to one record based on
previous selections on the form.
My question is how to get the one record to display in the combo box
automatically, so the user does not have to click the down arrow and
select
the one record.
The combo box name that I want to display the filtered record is:
cboCurrRateAmt
Control Source of the combo box: CurrRateAmt
Field in the tblFacilityRates that I want to display: RateAmt

SQL Row Source:
SELECT tblFacilityRates.RateAmt, tblFacilityRates.FacilityID,
tblFacilityRates.RateTypeID, tblFacilityRates.RateTypeDescription,
tblFacilityRates.RateType
FROM tblFacilityRates
WHERE
(((tblFacilityRates.FacilityID)=[forms]![frmEnterMonthlyVisits].[cbofacilityID])
AND
((tblFacilityRates.RateTypeID)=[forms]![frmEnterMonthlyVisits].[cboRateTypeID])
AND
((tblFacilityRates.RateTypeDescription)=[forms]![frmEnterMonthlyVisits].[txtposition]))
ORDER BY tblFacilityRates.FacilityID, tblFacilityRates.RateTypeID,
tblFacilityRates.RateTypeDescription
WITH OWNERACCESS OPTION;

Thanks for your input.

novice user,
Bill

 

[bpauley]

No dice, I get the same number for all of the records when I scroll through
them.
Thanks for the reply. Any other suggestions.
Bill

Try the CurrentEvent of the form.

thank you for the reply.
Where were you suggesting to but your response?
Bill

Try:
Me.cboCurrRateAmt = Me.cboCurrRateAmt.ItemData(0)

[quoted text clipped - 29 lines]

novice user,
Bill

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[bpauley]

I believe my original post explained that the control source of the
cboCurrRateAmt is CurrRateAmt.
Does that mean that it is bound?
Maybe I should be looking to make the drop-down active on "gotfocus" of
cboCurrRateAmt. That is make it drop-down whenever the user tabs to the
control. Can you assist with that process?
Again I am a somewhat novice user, please explain in detail.
Thank for your assistance.
Bill

I assume it is an unbound ComboBox so how about:

Me.cboCurrRateAmt.Requery
Me.cboCurrRateAmt = Me.cboCurrRateAmt.ItemData(0)

..in the Current Event of the Form.

No dice, I get the same number for all of the records when I scroll
through
them.
Thanks for the reply. Any other suggestions.
Bill

Try the CurrentEvent of the form.

[quoted text clipped - 7 lines]

novice user,
Bill

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[bpauley]

Nothing displays when I go to new record (the first 3 combo boxes on the
form set what is displayed in cboCurrRateAmt)
Bound col is 1
column count is 5
widths: 0.7";0.65";0.65";0.5";0.5"

You are correct Bill that the ComboBox is in fact bound. Sorry for not
reading your first post more carefully. Does anything display in the cbo
when
you move to a new record? What is the Bound Column of the cbo and what do
you
have in the Column Count and Column Widths properties?

I believe my original post explained that the control source of the
cboCurrRateAmt is CurrRateAmt.
Does that mean that it is bound?
Maybe I should be looking to make the drop-down active on "gotfocus" of
cboCurrRateAmt. That is make it drop-down whenever the user tabs to the
control. Can you assist with that process?
Again I am a somewhat novice user, please explain in detail.
Thank for your assistance.
Bill

I assume it is an unbound ComboBox so how about:

[quoted text clipped - 14 lines]

novice user,
Bill

 

[bpauley]

I did find answer to the dropdown question I asked.
place Me!cboCurrRateAmt.dropdown on on enter. When the user tabs to the
combo box the dropdown drops.

I believe my original post explained that the control source of the
cboCurrRateAmt is CurrRateAmt.
Does that mean that it is bound?
Maybe I should be looking to make the drop-down active on "gotfocus" of
cboCurrRateAmt. That is make it drop-down whenever the user tabs to the
control. Can you assist with that process?
Again I am a somewhat novice user, please explain in detail.
Thank for your assistance.
Bill

I assume it is an unbound ComboBox so how about:

Me.cboCurrRateAmt.Requery
Me.cboCurrRateAmt = Me.cboCurrRateAmt.ItemData(0)

..in the Current Event of the Form.

No dice, I get the same number for all of the records when I scroll
through
them.
Thanks for the reply. Any other suggestions.
Bill

Try the CurrentEvent of the form.

[quoted text clipped - 7 lines]
novice user,
Bill

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[bpauley]

No difference. the combo box still requires tabbing to it, I now have it set
to dropdown on enter. So I have to click the dollar amount and tab on.
Thanks for your patience with this problem, much appreciated.
Bill

So this field in the table has not been filled in yet correct? Did you
try:

Me.cboCurrRateAmt.Requery
Me.cboCurrRateAmt = Me.cboCurrRateAmt.ItemData(0)

..yet in the Current event of the form?

Nothing displays when I go to new record (the first 3 combo boxes on the
form set what is displayed in cboCurrRateAmt)
Bound col is 1
column count is 5
widths: 0.7";0.65";0.65";0.5";0.5"

You are correct Bill that the ComboBox is in fact bound. Sorry for not
reading your first post more carefully. Does anything display in the cbo

[quoted text clipped - 18 lines]

novice user,
Bill

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com