Re: List Box to Open Form

Tina,
Thanks for the help! It worked, but can you now tell me how to keep a second
popup from opening if it has null values. Ex: If "Receiving" is null, per
your code below, it opens. I have another popup based on field "Disassembly"
being null. I don't want both of them to open up when my main form opens,
only "Receiving" and then when it is no longer null have "Disassembly" start
opening. Is this possible?

"tina" wrote:

> try adding code to the Current event of fGeneralInfo, as
>
> If IsNull(Me!Receiving) Then
> DoCmd.OpenForm "fPopUpReceiving"
> End If
>
> if you only want the pop-up to open on existing records (not a new, blank
> record) then use
>
> If Not Me.NewRecord And IsNull(Me!Receiving) Then
>
> hth
>
>
> "Pam" <pamnospam@xxxxxxxxxxxxxxxx> wrote in message
> news:eyWTNrdHGHA.1312@xxxxxxxxxxxxxxxxxxxxxxx
> > Tina,
> > I got it to work - thanks so much!
> > Can you help me open a pop up form already created based on a field being
> > blank on another form? Ex: "fGeneralInfo" has field "Receiving". If
> > "Receiving" is blank, I want form "fPopUpReceiving" to pop-up when
> > fGeneralInfo opens with job info. I hope this isn't too confusing! Once
> > again, the help is greatly appreciated!!
> >
> > "tina" <nospam@xxxxxxxxxxx> wrote in message
> > news:_DVzf.275981$qk4.267767@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > >> What I want to be able to do is click
> > >> on one of the jobs in the list box and have it open the form for that
> > >> specific job number?
> > >
> > > do you mean "open *another* form" for the specific job number? if so,
> you
> > > can run code from the listbox control's Click event or AfterUpdate event
> > > to
> > > open the form with a WHERE clause, something along the lines of
> > >
> > > DoCmd.OpenForm "FormName", , , "JobNumber = " _
> > > & Me!ListBoxName
> > >
> > > if the job number is a Text field, rather than a Number field, the
> syntax
> > > would be
> > >
> > > DoCmd.OpenForm "FormName", , , "JobNumber = '" _
> > > & Me!ListBoxName & "'"
> > >
> > > in either case, the assumption is that the job number field is the bound
> > > column in the listbox control.
> > >
> > > hth
> > >
> > >
> > > "Pam" <pamnospam@xxxxxxxxxxxxxxxx> wrote in message
> > > news:eeEBu9THGHA.1728@xxxxxxxxxxxxxxxxxxxxxxx
> > >> I have a combo box and a list box on a form. The combo box lists tech
> > > names
> > >> from a tech list table. The list box lists jobs related to each tech
> as
> > >> they are selected in the combo box. What I want to be able to do is
> > >> click
> > >> on one of the jobs in the list box and have it open the form for that
> > >> specific job number?
> > >> Any help is greatly appreciated!!
> > >> Thanks,
> > >> Pam
> > >>
> > >>
> > >
> > >
> >
> >
>
>
>
.

Relevant Pages

  • Re: Dual purpose command button
    ... I would also put the intelligence in the command button's On Click Event ... Form close event of the errors form, check to see if the record has any data. ... "tina" wrote: ... > result should be either a) frm_OrderErrors opens showing only the existing ...
    (microsoft.public.access.forms)
  • Re: List Box to Open Form
    ... Public Function HoursAndMinutesAs String ... >> Tina, ... >> your code below, it opens. ... >>> hth ...
    (microsoft.public.access.forms)
  • Re: project already open
    ... There also may be the case, when some user opens a project and after closing ... "moma" folder, ... "tina" wrote: ...
    (microsoft.public.project)
  • Re: recovery tool
    ... If OE is not opening, its usually due to a corrupt folders.dbx file. ... that and then see if OE opens. ... Because of this tendency of attachments to infect, ... Turn off email scanning in your antivirus software. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: data source with 508 fields
    ... opening with Word 2003/2007) ... When opening just the file (with or without the confirm conversion ... and once when it opens the .doc that is created from the ... You should be able to test that by disconnecting the data source from ...
    (microsoft.public.word.mailmerge.fields)