Combo Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,
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...
 
This shouldn't be that difficult. If you only have two tables, place them
both in the record source query of the report and join the appropriate
fields from the two tables. Add the field with the text you want in the list
of fields so you can display it in the report.

Then, consider never ever using lookup fields in table designs.
http://www.mvps.org/access/lookupfields.htm


--
Duane Hookom
MS Access MVP

Zanstemic said:
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...
Click to expand...
 
Back
Top