Combo Field

Z

Zanstemic

The field is defined as a combo box that is using another table to supply the
information. The table is made up of RecordID and RecordName. The combo
field works well to select the RecordName but when called in a Report using
the Form Field Tag, it returns the RecordID.

Any suggestions
 
D

Duane Hookom

Add "another table" to the report's record source and join the RecordID
field to something. This will allow you to add the [RecordName] field to the
report's record source fields.
 
Z

Zanstemic

Duane,
Can you clarify for me.

Currently I have two tables. The first is the table that has the field
RecordName as a combo box. This field is referencing a second table that has
a list of RecordNames. This second table has a RecordID and a RecordName
field.

Should I add a third table or can I add a field to one of these tables?

Thanks for the help

Duane Hookom said:
Add "another table" to the report's record source and join the RecordID
field to something. This will allow you to add the [RecordName] field to the
report's record source fields.

--
Duane Hookom
MS Access MVP

Zanstemic said:
The field is defined as a combo box that is using another table to supply
the
information. The table is made up of RecordID and RecordName. The combo
field works well to select the RecordName but when called in a Report
using
the Form Field Tag, it returns the RecordID.

Any suggestions
Click to expand...
Click to expand...
 
Top