Want to display one field from a query, on a form -- unbound control?

[Rachel Garrett]

I have a very carefully designed query that pulls from 7 different
tables to get the information that I need for a form. Referential
integrity is enforced, so it is still editable.

However...I was asked to add one additional piece of data ([Current
score]) to my form. The new data item comes from a crosstab query.
Although the crosstab query includes an indexed field ([Question
Name]) that I could join to the rest, it would show up but make the
form uneditable.

I think I can make this work, but I don't know how to refer to a table
that's in the database but not part of the source for the form. I've
searched, and it looks like an unbound control is what I need, but I
don't understand what properties I need to change. There is one for
Control Source, but wouldn't I need two at minimum -- one to look up a
value, and one to say which matching row to return once it finds a
matching value? I'm puzzled...

Thanks,
Rachel Garrett

 

[Golfinray]

Crosstab queries are not editable. If you join them to other tables or
queries it will cause them to be uneditable. Could you build a query from the
original information you used to make the crosstab and query out of that? I
think that might be the simplest to do.