Re: List Box to Open Form

if there is a possibility that a record will have Receiving data entered,
but not Disassembly data entered, *when you move to that record*, then
change the Current event to

If IsNull(Me!Receiving) Then
DoCmd.OpenForm "fPopUpReceiving"
ElseIf IsNull(Me!Disassembly) Then
DoCmd.OpenForm "DisassemblyFormName"
End If

again, if you don't want the pop-ups on new blank records, then change the
above to

If Not Me.NewRecord Then
If IsNull(Me!Receiving) Then
DoCmd.OpenForm "fPopUpReceiving"
ElseIf IsNull(Me!Disassembly) Then
DoCmd.OpenForm "DisassemblyFormName"
End If
End If

aside from the above, add the following code to the Receiving control's
AfterUpdate event, as

If IsNull(Me!Disassembly) Then
DoCmd.OpenForm "DisassemblyFormName"
End If

hth


"PHisaw" <PHisaw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CFF120EA-3347-4A76-BE1E-02B9DE8758E1@xxxxxxxxxxxxxxxx
> 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: Repost - Open Form
    ... I have a table for Tech Names, a table for Jobs, and a WorkLog table brings ... subform is on is linked to the subform by job number. ... Unbound combo box "CboJobSelect" lists job numbers in db ... Form opens "fTTGeneralInfo" that lists info about job ...
    (microsoft.public.access.forms)
  • Re: Repost - Open Form
    ... Tech & Job). ... even keep the main form and subform records "in sync" for you if you tell it ... Unbound combo box "CboJobSelect" lists job numbers in db ... Form opens "fTTGeneralInfo" that lists info about job ...
    (microsoft.public.access.forms)
  • Re: Tech says the problem is XP, is it?
    ... The tech is full of it. ... Now, that said, your comment that "I tried the paper clip insertion, it ... > hitting F2 upon startup and then do a NUM LOCK, ... Subsequently, it opens some times ...
    (microsoft.public.windowsxp.general)
  • Re: Repost - Open Form
    ... Unbound combo box "CboJobSelect" lists job numbers in db ... Tech selects his name from CboTech and a job from CboJobSelect ... Form opens "fTTGeneralInfo" that lists info about job ...
    (microsoft.public.access.forms)
  • Re: Parameter Value??
    ... references the field Tech. ... there is open time on a job and then the reminder form opens. ... Is CboTech the name of a field in the ... a list box that will populate jobs based on tech name in Combo8. ...
    (microsoft.public.access.forms)