Re: Combo Box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Fred

I'm still a bit short on context. Are you trying to do this within a table?
Tables are great for storing data, but lousy for managing the display of
data.

Are you trying to do this in a form? If so, it sounds like you are saying
that you want to have the values in the second combobox depend on the choice
in the first, and the third on the second, and so on. If this is a fair
description, and if you'll do this in a form, then you need to look up
"cascading comboboxes" in HELP, at mvps.org/access, or via some search tool
(e.g., Google.com).

If you aren't doing this in a form, search this group (tablesdbdesign) for
the many reasons NOT to use "lookup" data types in table definitions.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Fred" <Fred@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:543184E9-E09A-4D27-9A04-7AC5853294D0@xxxxxxxxxxxxxxxx
Sorry about that. I made a table which has reason codes, Reason
Description,
Days added on and Points which have 54 total records.. Now I am trying to
make combo boxes that display all 4 types (Reason code, Reason
Description,
Days added on and Points) in combo boxes. For example if Reason code 10 is
needed, reason description should be "Absence Doc Rec'd, Days added on s/b
1
and points s/b 0. Though when I try to make 4 combo boxes for each field,
it
doesn't work.

"Jeff Boyce" wrote:

Fred

We're not there. We can't see your database. We don't know how you've
designed your table.

Since you've posted in the tablesdbdesign newsgroup, should we assume you
are trying to do this directly in a table, rather than where it would
properly belong, in a form?

"All information" is a VERY broad statement ... can you narrow it down a
bit, or describe a bit more what you mean by this?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Fred" <Fred@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1D7E7C6B-EB7F-48B4-BFAE-C0D3B19A20FA@xxxxxxxxxxxxxxxx
How can I use 4 combo boxes to each show all information from a table?
I
am
only able to get 2 combo boxes to show 2 table fields.





.

Relevant Pages

  • Re: Combo Box
    ... update the other combo boxes from the same table It will allow ... reason code, but any more than 2 and it doesn't work. ... "Jeff Boyce" wrote: ... and points s/b 0. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Calculate Total Hours Worked For Week Based On Check Boxes.
    ... We have Care Givers called Attendants that go out to our Clients homes to ... Attendant name and the subform part which has there schedule "start time", ... boxes that represents the days worked for that week. ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.forms)
  • Re: TCO and users/box
    ... I work at a scientific institute; we do scientific computation, ... with number of boxes, but does scale up with number of boxes. ... Resource use is inefficient, given the statistical pattern of usage. ... IMHO this isn't a good reason for one workstation/user unless it can be ...
    (comp.os.linux.hardware)
  • Re: Combine Text Boxes
    ... But what I am trying to do is combine the 3 text boxes.. ... "Jeff Boyce" wrote in message ... [DOBDay] ... Once I have that data I would like to have text box to display the age.. ...
    (microsoft.public.access.forms)
  • Re: Copying the last record to a new record
    ... The reason I went with access is the huge amount of data, ... "Jeff Boyce" wrote: ... you're treating it as if it were a spreadsheet, ... Microsoft Office/Access MVP ...
    (microsoft.public.access.macros)