Re: List Box to Open Form
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Thu, 19 Jan 2006 23:53:30 GMT
> 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
>
>
.
- Follow-Ups:
- Re: List Box to Open Form
- From: Pam
- Re: List Box to Open Form
- References:
- List Box to Open Form
- From: Pam
- List Box to Open Form
- Prev by Date: Re: Accessing .mdb file from Shared Drive by multiple Users
- Next by Date: Re: Accessing .mdb file from Shared Drive by multiple Users
- Previous by thread: List Box to Open Form
- Next by thread: Re: List Box to Open Form
- Index(es):
Relevant Pages
|
Loading
