Re: Query Form

From: Rick B (anonymous_at_discussions.microsoft.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 10:54:32 -0500

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

Relevant Pages

  • Re: Query Form
    ... >ID that is made of three separate fields (Year,Number, ... I have built combo box for the year and pull ... >I want to do the same for sequence, ...
    (microsoft.public.access.formscoding)
  • Re: Update a number field incrementally
    ... *separate fields* which can be concatenated as needed for display. ... and sequence - including total amount used per day? ... Order number, order date, ship date, and Reference. ... I need the query to be able to run automatically regardless of how many ...
    (microsoft.public.access.queries)
  • Re: Choice of data structures
    ... Lisp's adjustable-array) in the order it ... I wanted to pull things out in sequence, I'd use the sorted keys to pull the ...
    (comp.lang.lisp)
  • Re: Choice of data structures
    ... > the data according to the hash (not really caring where it ended up). ... > I wanted to pull things out in sequence, I'd use the sorted keys to pull ... Sounds like you want a Tree to me, not a hash. ...
    (comp.lang.lisp)
  • wi0: detach/reattach on pcmcia card pull?
    ... laptop, but occasionally I need to pull it to use the built in nic. ... To unsubscribe, ...
    (freebsd-current)