Combobox NotInList problem

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

Hi

I have a combobox on a form that lists email addresses that I use for
emailing my reports

What I am trying to do is have the ability to add another email address if
its not in the list

The combobox is unbound & recordsource is tblEmailAddresses. This table just
has 3 fields, EmailAddress, FirstName & Surname

At present when NotInList fires & it tells me that its not in the list &
opens my form to let me enter the details.
Problem is I cannot work out how to pass the already entered email address to
the new form so that I dont have to retype the email address.

Any help would be appreciated. Its been a long say & I'm feeling a bit thick!

Thanks
die_laffin

--
I wish I knew more...

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200603/1
.

Relevant Pages

  • Re: ComboBox ItemData?
    ... > The idea with the comboboxes was to use them as lists of choosable items. ... > I.e. the possible values the property bound to a combobox could have, ... >> databinding for comboboxes since they contain multiple data ... >>> private void InitializeComponent() ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: ComboBox ItemData?
    ... not clear why you couldn't use complex databinding to accomplish it. ... > fill a combobox with those values. ... >>> The idea with the comboboxes was to use them as lists of choosable ... > private void InitializeComponent() ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Dependent ComboBoxes as Critiria for VLOOKUP or OFFSET
    ... The problem with that solution is the design of the secondary lists. ... What I need is to choose the vendor from ComboBox 1 and ... have the dates for only that store show up in ComboBox 2 without ... I have a UserForm with 3 ComboBoxes and several TextBoxes. ...
    (microsoft.public.excel.programming)
  • Re: Does anyone use .NET applications?
    ... > listbox for longer lists. ... While I agree that radiogroups (or checkboxes for multiple selections) are ... the combobox selected initially, then Alt-Down arrow to open it up. ... which only uses initial letters to choose, ...
    (borland.public.delphi.non-technical)
  • Re: Cant populate combobox list with 1 item
    ... you have to create a loop and 'add' each single entry with additem. ... > same code to all comboboxes - most of which have more than one entry. ... >> use the additem method of your combobox. ... I am populating combobox lists with the following code: ...
    (microsoft.public.excel.programming)