Re: AfterUpdate Requery

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

At first your solution caused some problems with data getting lost in all of
the records that were displayed by the form but once I set it Data Entry to
"Yes" it worked..

Thanks!

"Carl Rapson" <mr.mxyzptlk@xxxxxxxxxxxxxxxxx> wrote in message
news:%23MYM$wdqHHA.5032@xxxxxxxxxxxxxxxxxxxxxxx
You can set a combo box to Null, which should clear any selection:

cbEquipType = Null

Carl Rapson

"James Bailey" <privacy@xxxxxxxxxxxxxx> wrote in message
news:eiElkUWqHHA.3296@xxxxxxxxxxxxxxxxxxxxxxx
I'm having a problem with Requery. I have 7 combo boxes that are
cascading. One gets it's data from the previous one. The first three
requery and blank out the combo boxes if the item that was selected isn't
in the new list. Although the last four do requery and get a new list,
they keep the previous selected text even if it isn't in the new list. I
set the Limit To List option but that didn't have an effect on the last
four combo boxes.



.

Relevant Pages

  • AfterUpdate Requery
    ... I'm having a problem with Requery. ... I have 7 combo boxes that are cascading. ... Private Sub cbVessel_AfterUpdate ...
    (microsoft.public.access.formscoding)
  • RE: Combo Boxes again
    ... Traditional setup is to have cascading combo boxes. ... name, requery the surname combo, select a surname, requery the phone combo. ... does that mean that the first two selections are ...
    (microsoft.public.access.gettingstarted)
  • Re: Combo Box Query: Listing a subset
    ... the following code allows me to requery the combo. ... The new idiosyncrasy involved the combo boxes not displaying previous ... display the previously entered data until you drop the list down. ... Once the query has run, the list is in memory and will ...
    (microsoft.public.access.queries)
  • Re: Requery combo box in subform
    ... If the subform is displayed in Single Form view, ... You just need to requery the dependent ... combo boxes in the subform's Current event. ... on table Diagnosis2 that is dependent on the value in combo box idcux. ...
    (microsoft.public.access.formscoding)
  • Re: Requery combo box in subform
    ... You just need to requery the dependent ... combo boxes in the subform's Current event. ... the after update event for the subform I have the following code to requery ... on table Diagnosis2 that is dependent on the value in combo box idcux. ...
    (microsoft.public.access.formscoding)