Display name field in Forms

[Bruce]

I am attempting to show a field on a form that is not included in the initial
record source. I have a form (Access 2002 sp 3, Windows XP professional
version 2002 sp 3) whose record source is (table) Master Invoice. One of
linked tables (one to many) lists the names associated with to the invoice
(Card holder name). I have tried several approaches to this situation to no
avail. The closest that I can get is by creating a Combo box with an inner
join to the Master Invoice (table) but the name is not displayed as part of
the process. Two questions: is there a way to code the Combo box to display
the name without bringing focus to the drop down arrow; Is there a better way
to display the name associated with this record?

 

[Arvin Meyer [MVP]]

I am attempting to show a field on a form that is not included in the
initial
record source. I have a form (Access 2002 sp 3, Windows XP professional
version 2002 sp 3) whose record source is (table) Master Invoice. One of
linked tables (one to many) lists the names associated with to the invoice
(Card holder name). I have tried several approaches to this situation to
no
avail. The closest that I can get is by creating a Combo box with an inner
join to the Master Invoice (table) but the name is not displayed as part
of
the process.

Two questions: is there a way to code the Combo box to display
the name without bringing focus to the drop down arrow; Is there a better
way
to display the name associated with this record?

Yes, add a textbox directly above the combo and set its ControlSource = to
the Combo. Set the combo Visible property to False.

I'd just do a DLookup or a recordset and fill a textbox with the value.

 

[Bruce]

Thank you Arvin, your help is really appreicated.