Re: Reporting Out Two Names w/Phone # from the Same Table

Good going Rich!

RichKorea wrote:
Thanks for the reply Bonnie,

The combobox on the form where the data's entered already pulls in multiple
columns, I'm trying to get two references to the same Contact_Table to work
on a report. Referencing two items from the ServiceReport table to different
contact ID's wasn't working until I added a Contact_1 table and setup
separate links, but since the field names were the same, I couldn't put those
into the query.

What I just tried was creating two subforms, one for each contact category,
that queries the contact table based on the contact_ID. I then link the
subforms to the contact_ID I get back from the main report's query, and this
appears to work.

Not sure I understand Rich but maybe it would help you to include the phone
number in the combobox query, then you can pull it from the combobox. You
[quoted text clipped - 25 lines]
Thanks
Rich

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200807/1

.

Relevant Pages

  • Re: References choice...
    ... Then you can use it in code, to use it in a query - you need to make a public function, which returns this variable value, and use this function in a query ... Best regards, ... Is it possible to define constant 'A' that would pick a value from combobox ... >> in general - you need to have min 3 references in Access ...
    (microsoft.public.access.modulesdaovba)
  • Re: macro where statement problem
    ... approach requires the user to memorize record IDs. ... You can add a combobox control to the header section of a form. ... and use a query to fill it with the various records IDs ... When clicking on the switchboard it pulls in the parameter ...
    (microsoft.public.access.formscoding)
  • Re: References choice...
    ... build query in the list of constants,... ... Best regards, ... made (when query relies on combobox value on form, ... in general - you need to have min 3 references in Access ...
    (microsoft.public.access.modulesdaovba)
  • Empty ComboBox
    ... My app works fine on my PC but when run on another PC the problem ... There is no data displayed in the combobox when it drops down on this ... The References look OK. ... The combo pulls it's list from an internal Table. ...
    (comp.databases.ms-access)
  • Re: stumped
    ... Make sure the *Bound* Column of the ComboBox is the Column that has a value ... that uniquely identifies the Customer, ... I'm now trying to write a query where this filed is joined to ... > customer table and pulls out the address for that customer. ...
    (microsoft.public.access.queries)