Re: List Box to Open Form

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
    ... 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: 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
    ... 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: Selective connection drops...
    ... Once it opens in Notepad, ... >Before trying to remove spyware using the programs ... >that you can have a clear HiJackThis Log for the experts ... >Most of what it lists will be harmless or even required, ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: List Box to Open Form
    ... fGeneralInfo opens with job info. ... > can run code from the listbox control's Click event or AfterUpdate event ... >> from a tech list table. ... The list box lists jobs related to each tech as ...
    (microsoft.public.access.forms)
Loading