Hi All,
I got a query as source for a form:
Select query1.*, query2.data from query1, query2
query1 selects all data from a table using 2 comboboxes as conditions.
query2 selects all data from a table using 1 textfield.
After the selection of the comboboxes I fid the record that is like the selection. All data from query1 are displayed decent. But query2 doesn't display. When I open query2, he displays the correct number (It is a count query) but in the textfield in my form he doesn't. Nou me![textfield].requery doesn't work, me.requery gives an error, and me.recalc doesn't work either.
Anyone have got anny clue on what the problem is and if the display in the textfield is, how can I refresh the textfield?
Johannes
I got a query as source for a form:
Select query1.*, query2.data from query1, query2
query1 selects all data from a table using 2 comboboxes as conditions.
query2 selects all data from a table using 1 textfield.
After the selection of the comboboxes I fid the record that is like the selection. All data from query1 are displayed decent. But query2 doesn't display. When I open query2, he displays the correct number (It is a count query) but in the textfield in my form he doesn't. Nou me![textfield].requery doesn't work, me.requery gives an error, and me.recalc doesn't work either.
Anyone have got anny clue on what the problem is and if the display in the textfield is, how can I refresh the textfield?
Johannes
