Display name field in Forms

  • Thread starter Thread starter Bruce
  • Start date Start date
B

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?
 
Bruce said:
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.
Click to expand...
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?
Click to expand...

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.
 
Back
Top