Re: refresh combo boxes on form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

you're welcome :)


"bpauley" <wlp46@xxxxxxxxxxx> wrote in message
news:O6%231sQ8pJHA.4448@xxxxxxxxxxxxxxxxxxxxxxx
Hello Tina,
I did as you suggested and also cleaned out some of the old code from past
attempts to get this to work and wallah! it is working.
Big Thanks to you and Sandy for your suggestions.
Bill

"tina" <nospam@xxxxxxxxxxx> wrote in message
news:M10wl.455703$Mh5.377305@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
try requerying the two dependent combobox controls on the *form's*
Current
event, as

Private Sub Form_Current()

Me!cboCurrRateAmt.Requery
Me!cboCurrPayRateAmt.Requery

End Sub

hth


"bpauley" <wlp46@xxxxxxxxxxx> wrote in message
news:uqk7zN2pJHA.3876@xxxxxxxxxxxxxxxxxxxxxxx
Hello Sandy,
Thanks for your response
I tried your suggestion, but I get the same result. I am probably not
explaining my situation very well.
When I enter a new record it works at expected. When I go to a
different
record, after entering a new record or opening the form, the rates in
the
combo boxes don't synchronize with the change in the first 3 combo
boxes.
I
will try to explain what I have.
I enter a contactid in the first combobox to select the employee and
type
(PT OT ST PTA COTA). The second combo box selects the facility the
employee
is working in. The third combo box selects the type of shift the
employee
is
working. So those three combo boxes filter a query down to the exact
rate
to
pay and bill for the employee hours. The two combo boxes that I am
trying
to
synchronize are cboCurrRateAmt and cboCurrPayRateAmt. Both display a
currency amount. In the query design grid behind the form, I have in
the
criteria of the ContactID, forms!frmEnterMonthlyVisits.ContactID; in
the
FacilityID, forms!EnterMonthlyVisits.FacilityID; in the TherID,
forms!frmEnterMonthlyVisits.TherID.
As I said, all works well until I move to a different record. The
CurrRateAmt and CurrPayRateAmt combo boxes do not update to the new
amounts
unless I requery the form.
Hoping you can make some sense of what I have tried to explain.
Thanks again for your suggestion. Any other ideas?
Bill

"Sandy Hayman" <help@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:#kBBc$vpJHA.1248@xxxxxxxxxxxxxxxxxxxxxxx
Hi Bill
In the after_update event of the combo box, use the following line
(replace combobox with your combobox name):

me.combobox.requery

Sandy

AA Absolute Access, ACT - Australia


"bpauley" <wlp46@xxxxxxxxxxx> wrote in message
news:%230WFdtvpJHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
How do I refresh combo boxes on a form?
I have two combo boxes dependant on the info in 3 other combo boxes.
the
two I need refreshed are cboCurrPayRate and cboCurrPayRate. All
works
exactly as planned, except when I change records by scrolling or by
using
the record change arrow, the rates behind the two combo boxes do not
update based on the current info in the other 3 combo boxes. When I
refresh the form the rates behind the combo boxes update as desired.
I have tried refreshing the form on the "onchange" event, but no
good.
Me!frmEnterMonthlyVisits.refresh
is the line I used.
Thanks
Bill






.

Relevant Pages

  • Re: refresh combo boxes on form
    ... Private Sub Form_Current ... I tried your suggestion, but I get the same result. ... combo boxes don't synchronize with the change in the first 3 combo boxes. ... I enter a contactid in the first combobox to select the employee and type ...
    (microsoft.public.access.forms)
  • Re: XP Pro Client wont accept incoming RDP Connection
    ... these boxes via RDP? ... These boxes do run Autocad with a fancy graphics card feeding 28" LCD ... Another suggestion was to remove them from the domain and then rerun the ... ConnectComputer wizard - don't really want to remove the boxes from the ...
    (microsoft.public.windows.server.sbs)
  • Re: refresh combo boxes on form
    ... Bill ... I tried your suggestion, but I get the same result. ... combo boxes don't synchronize with the change in the first 3 combo boxes. ... I enter a contactid in the first combobox to select the employee and type ...
    (microsoft.public.access.forms)
  • Re: refresh combo boxes on form
    ... displayed names of the dependent combo boxes are showing names from the query ... the IDs stored are correct but the names are wrong. ... I tried your suggestion, but I get the same result. ... (replace combobox with your combobox name): ...
    (microsoft.public.access.forms)
  • Re: Portrait and landscape in one document easier.
    ... in a series of different boxes, ... >> This post is a suggestion for Microsoft, ... >> suggestions with the most votes. ... To vote for this suggestion, ...
    (microsoft.public.word.pagelayout)