RE: Not in list event Macro trouble

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Chris Reveille (anonymous_at_discussions.microsoft.com)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 07:29:07 -0800

You could put this on the on close event of the form you
are closing or on the onclick event of the combobox

Chris

>-----Original Message-----
>Great Chris.. But Where do I write this code I have used
a Macro to open
>the other form
>
>ON form a if a value is put in that is not in the table
The pop up info box
>open says click here to add color to database that is
the msg in the macro
>then i used the openform to open the COLOR form which it
does but the
>microsoft error pop up also displays after the open form
i used the refresh
>to refresh the color table I think I need to put more
items in the action
>thanks for your help
>
>bart
>
>"Chris Reveille" wrote:
>
>> After you have entered the new color you need to refresh
>> the combo box. When closing the color form add
>> Forms!OtherFormName!comboboxName.Requery
>>
>> Chris
>>
>> >-----Original Message-----
>> >I have a Combo box in a form that looks up a color for
>> block. if the color
>> >entered on the production form is not in the color table
>> the color form
>> >opens. with a mesage click here to add color to list. The
>> Form Opens and
>> >data can be enter. then the user closes the color form and
>> the new color is
>> >still not available in the production form . And how do I
>> stop the microsoft
>> >error from popping up also.
>> >thanks
>> >--
>> >Bart
>> >.
>> >
>>
>.
>

Relevant Pages

  • Re: we jump the raw sticker
    ... Jeanette seeks the plate around hers and truly opens. ... It should deeply promise worthwhile and loves our open, ... as the enigma cleans outside their kettle. ... Chris and Cypriene walked the glad deserts against bad exit. ...
    (uk.rec.gardening)
  • Re: Save record using a dialog
    ... closing the form, closing Access, applying a filter, changing the sort ... Access opens the code window. ... Private Sub Form_BeforeUpdate ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.forms)
  • Re: remember the state of the document after closing
    ... the user saved the document before closing it, then it can all be loaded ... services on a paid consulting basis. ... had a macro that allows retrieving data from document back to the form. ... and opens up the same document, clicking on Editing Form button that ...
    (microsoft.public.word.vba.general)
  • Re: here comes the sun again....
    ... after closing in like a trap, each day the world now opens out ... another bit until even our toes get warm.... ...
    (uk.politics.misc)
  • RE: Run time error
    ... Everything opens and closes without problems until I deselect the ... Display Navigation Pane option under Current Database Options. ... opens the form from the switchboard, then closes Access (without closing the ...
    (microsoft.public.access.forms)