Re: Problem with Valid Event in Combobox

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Des (des_at_address.invalid)
Date: 08/29/04 

Date: Sun, 29 Aug 2004 22:14:40 +0100

Subhash wrote:
> I have a combobox whose value is initialized to blank on entry to the
> form. The list does not have blank as one of the value. Its Valid
> Procedure checks for blank value. Howeverf, when that combobox has
> focus and I press Tab key, the focus moves to the next control
> without validating the current value.
>
> Any ideas how I can fix this.
>
> Thanks.

Use the lostfocus event.

Des

Relevant Pages

  • RE: ComboBox - changing entry
    ... combo requeries but the newdata does not match the record that was just added ... Can you change the NewData variable to the altered ... I've always wanted to be able to allow the user to change their entry in case ... and it is added to the recordsource table and the combobox is satisfied. ...
    (microsoft.public.access.forms)
  • Re: Select from drop down list via typing text?
    ... I've set everything up according the instructions on the ConTextures Page and ... message if the entry doesn't match one in the validation list? ... named range from that workbook as your list source. ... and a combobox appears -- font size can be ...
    (microsoft.public.excel.worksheet.functions)
  • RE: ComboBox - changing entry
    ... Response As Integer) ... Set rst = Me.RecordsetClone ... I've always wanted to be able to allow the user to change their entry in case ... and it is added to the recordsource table and the combobox is satisfied. ...
    (microsoft.public.access.forms)
  • Re: combo box select
    ... Are you wanting to use a combobox instead of a textbox on the form, ... allowing the user to select an entry instead of having to type the full ... The student and uniform tables are related by studentID and if I use ...
    (microsoft.public.access.forms)
  • Re: Update subform based on Mainform combobox selection
    ... Is the combo box to which you refer bound or unbound. ... the value of the entry in the table does not ... If you have a child/parent link between the form & subform, ... > the data selected in the combobox. ...
    (microsoft.public.access.forms)