Re: View Active choices in combobox...

That part I get but I since I am using FE/BE DB what would be the least
amount of resources and time. Mainly what even should I put this requery
in. I am going to play around with different variations, just seeing if
anyone had any ideas.


"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:zSMae.9$461.5@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> "Pelton98" <Pelton98@xxxxxxxxxx> wrote in message
> news:eB%23COhJSFHA.3076@xxxxxxxxxxxxxxxxxxxxxxx
>> What is the best way to only allow active choices in a combobox..
>>
>> I have a combobox referred to a table that has an end date for the code.
>> I want only codes to show that have an end date that is null or > Date()
>>
>> I have been able to do this but for historic records that used the old
>> value won't display because they aren't in the record source.
>>
>> I have tried several different methods one is On current select the ones
>> I want or where the Code Id is equal to Forms.Code.value. This method
>> works but the records source must requery on every record change. [snip]
>
> The RowSource for the ComboBox needs to Requery with every record change.
> Is that what you meant? Why is that a problem? All of your other
> suggestions also require that the ComboBox be requeried.
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>


.

Relevant Pages

  • Re: Updateing a combobox
    ... Private Sub Combo0_NotInList ... Macro object name: Macro1 ... > the combobox must be something within the list or empty. ... > because the field cannot requery while text is present. ...
    (microsoft.public.access.formscoding)
  • Re: [VFP7] Grid mit abhaengigem Combofeld
    ... Stehen in der ComboBox nicht die richtigen ... REQUERY(). ... Prev by Date: ... Next by Date: ...
    (microsoft.public.de.fox)
  • Re: Current Row or similar for query-based combo box
    ... The requery solution is working very well. ... You can use the form's current event to force the combobox to be requeried. ... form.in my combobox query I am able to get the intended result. ... rows that need other values to display will suddenly display blank. ...
    (microsoft.public.access.queries)
  • RE: Continuous Form and ComboBox
    ... the ComboBox on the Uncreated Next Record gets ... created before the AfterUpdate event on the Current record fires. ... I did a requery on the GotFocus event and it all works perfectly. ... Post the RowSource query SQL. ...
    (microsoft.public.access.forms)
  • Re: Different types of Boxes
    ... You need to requery the combobox, but after the new value is saved. ... Or get fancy and set variable to True in the Before update event if the ... An unbound text box is usually used as a calculated control. ...
    (microsoft.public.access.gettingstarted)