Re: Query Form
toni.jimenez_at_srs.gov
Date: 07/19/04
- Next message: Marshall Barton: "Re: Displaying an instance of a form"
- Previous message: anonymous_at_discussions.microsoft.com: "Unbound form"
- In reply to: Rick B: "Re: Query Form"
- Next in thread: Marshall Barton: "Re: Query Form"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 09:20:07 -0700
Thanks. If I knew what things were called it would be
easier to search. Will search for that.
Toni
>-----Original Message-----
>Sounds like you want a combo box to display contents
based on the entry in a
>preiously selected combobox? If that is true, do a
search for "cascading
>combo" box. This has been asked and answered countless
times in these
>newsgroups.
>
>Rick B
>
>
>"toni.jimenez@srs.gov"
<anonymous@discussions.microsoft.com> wrote in
>message news:2ede301c46da5$8df71c30$a601280a@phx.gbl...
>Hi,
>
>I am very NEW to Access but an Oracle Developer for the
>past 10 years. What I am trying to do is build a query
>screen to get parameters to send to a report. I have an
>ID that is made of three separate fields (Year,Number,
>Sequence). I have built combo box for the year and pull
>the distinct year from the table. I have built another
>comb box for the number but can't figure out how to have
>it just pull up the numbers that correspond for that
>year. If anyone is an Oracle programmer this would be the
>same as building a LOV for the Number field with this
>select as the record group query:
>
>Select Number
>from table_name
>where year=block.year
>
>I would do this all as non-base table (I think this is the
>same as unbounded) as I am only wanting to get the
>criteria not update the table and then build the
>where_clause to send to a report.
>
>I want to do the same for sequence, pull the sequence
>numbers in a combo box for the year AND number. I can
>just write the select stmt if I can figure out the right
>syntax.
>
>Thanks,
>
>Toni
>
>
>.
>
- Next message: Marshall Barton: "Re: Displaying an instance of a form"
- Previous message: anonymous_at_discussions.microsoft.com: "Unbound form"
- In reply to: Rick B: "Re: Query Form"
- Next in thread: Marshall Barton: "Re: Query Form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
