Recent content by GeoByte

Hy Folks, I'm building a great form with a subform holding the dataview of a query. On the main form I have some combo's, whitch act as filters for the subform. Now i added a pie-chart (ms-graph) whitch responds to the recordset on the subform. It works like a charm without any VB. Now I want...

Hi Viper, Just make a query and add an expression as the fieldsource like Fieldmerge: [Field1] & " " & [field2] Goodluck!

This is exactly what I want. Thanks a lot. Now I can get on with it. The key is to use a query as the recordsource, which reflect the relations. Now i'll try it out on my projects form. Thanks again!:)

Here is a sample. In the testform I want to combine the 2 fields in the third, (now showing the key-value. Many Thanks

It's on the subform I think this also applies to reports. Still struggeling..

lookup-values Hay Keith, Yes, the source is the query [qryBPSverhardebaansoort]. This query is put on the subform (as a form). So I'm constructing an expression in an unbound textbox. I want to construct a string from multiple query-fields, not showing the key-values but the lookup-values as...

Hay Keith, Yes, the source is the query [qryBPSverhardebaansoort]. This query is put on the subform (as a form). So I'm constructing an expression in an unbound textbox. I want to construct a string from multiple query-fields, not showing the key-values but the lookup-values as with the...

Hay Folks, I'm having trouble with a subform. My subform (dataform) has a lot of fields. I want to reduce them by combining some fields with an expression. This would save some space on the form. The problem. I cant get the expression right to show real values instead of key-values. Here's the...