Change ID to Text - Query Continuous Form View

[Brightspark98]

Hi,



I have a query set up in continuous form type.

The values displayed are correct.

How do I view the Text Instead of the ID?

Ie. Change

ID	Injury	Area
1	3	4

to

ID	Injury	Area
John Smith	Cut	Arm

Many Thanks

[CJ_London]

two ways:

If the form is to be updateable, change the controls from textbox to combobox (right click on the control and select change) then a) populate the rowsource with a query to lookup the value (something like, "SELECT ID, employeename FROM tblemployees"), then b) change to columncount to 2, the bound column to 1 and the columnwidths to 0 (which will affect only the first (ID) column)

if the form is not to be updateable, modify your query to join to employee, injury etc and drag down the relevant text fields

[Brightspark98]

Thanks, I went with the second option.