Re: List Box to Open Form

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)
  • error 3048 cannot open any more databases
    ... Most of these are short lists. ... Each listbox opens a form with further details of the list. ... client doctor form has a combo to select a doctor. ... I've been careful to close any recordsets I've ...
    (microsoft.public.access.formscoding)
Loading