I make this more complicated than I need but it's fun.
1) There are three main items: A. Jobs B. Contacts C. Notes
2) Jobs are related to multiple Notes.
3) Multiple Jobs are related to multiple Contacts. To solve this I use an
intermediate table called "Contact Relations" i.e. RelationID, ContactID, and
JobID.
4) The only field that shows when I select a contact is "ContactID" from the
"Contact Relations" table. The Form source is a query that incorporates both
the "Contact Relations" table and the "Contacts" table the Name, Phone etc.
To cause these to show on the combo box I have to place that field from the
query over top the combo box.
Now the question. When I make a selection from the combo box OR when I open
the form, the first record does not show the the "overlayed" fields. How do
I get those fields to show in both cases (i.e. 1) upon opening the form and
2) upon selection)?
--
Chris Hayes
Newby
"Jeff Boyce" wrote:
> Chris
>
> I don't understand what you mean by "a related name field to cover that
> combo box".
>
> Are you saying you have a combo box AND a text box? If so, you (and Access)
> are working harder than you need to.
>
> A combo box allows for multiple fields to be displayed while it it dropped
> down. This makes it easier to identify the correct row/record. A combo box
> also allows one field to be stored and another to be displayed. This is
> done by setting the width of the "bound" field to 0 ... and is usually done
> by making the ID field the first field in the combo box's underlying query,
> then setting the width to 0.
>
> Or am I missing something?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Newby" <hayes.cs(remove this)@gmail.com> wrote in message
> news:3DED0562-2E1B-44FD-9529-(E-Mail Removed)...
> >I know this has been discussed before but it's hard to find.
> >
> > my combo box in a sub form selects a numerical value stored as the ItemID
> > but I have to use a related "name" field to cover that combo box so it is
> > identifiable to the user. I have multible: Name, Company, Phone, Fax
> > that I
> > need to show
> >
> > How do I get those to stand out 1) after the combo box selection and 2)
> > when
> > the form opens?
> > --
> > Chris Hayes
> > Newby
>
>
>
|
Similar Threads
