Text fields in Forms....how to link

[Guest]

I have a form that when a combo box is selected, the result is used as a
criteria in a query. The query then displays the associated field values
based on the selection of the combo box.

Now, I want the results (as a text box or even subform) from the query to
appear on the same form that has the combo box. I want to see the results
every time I change my selection in the combo box...realtime.

I tried to make the control of the text box a resulting field of the query,
but it gives me #Name?. I also tried to insert a subform, but it does not
refresh when the selection in the combo box is changed.

Help.....please.....

 

[Guest]

Put the combo box in the header of the form and make sure the reference of
the combo name is in the criteria of the query. The query is the source of
the form.

In the "after update" event of the combo try

[forms]![form name].requery

to change the records.

I hope that is clear

 

[Guest]

I tried this, but the records did not change in the text fields. I have the
control source for the text fields set as fields in the query that the combo
box is a criteria in.

Thanks....

Put the combo box in the header of the form and make sure the reference of
the combo name is in the criteria of the query. The query is the source of
the form.

In the "after update" event of the combo try

[forms]![form name].requery

to change the records.

I hope that is clear

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

I have a form that when a combo box is selected, the result is used as a
criteria in a query. The query then displays the associated field values
based on the selection of the combo box.

Now, I want the results (as a text box or even subform) from the query to
appear on the same form that has the combo box. I want to see the results
every time I change my selection in the combo box...realtime.

I tried to make the control of the text box a resulting field of the query,
but it gives me #Name?. I also tried to insert a subform, but it does not
refresh when the selection in the combo box is changed.

Help.....please.....

 

[Guest]

Try the form's "current" event instead.

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

I tried this, but the records did not change in the text fields. I have the
control source for the text fields set as fields in the query that the combo
box is a criteria in.

Thanks....

Put the combo box in the header of the form and make sure the reference of
the combo name is in the criteria of the query. The query is the source of
the form.

In the "after update" event of the combo try

[forms]![form name].requery

to change the records.

I hope that is clear

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

I have a form that when a combo box is selected, the result is used as a
criteria in a query. The query then displays the associated field values
based on the selection of the combo box.

Now, I want the results (as a text box or even subform) from the query to
appear on the same form that has the combo box. I want to see the results
every time I change my selection in the combo box...realtime.

I tried to make the control of the text box a resulting field of the query,
but it gives me #Name?. I also tried to insert a subform, but it does not
refresh when the selection in the combo box is changed.

Help.....please.....

 

[Guest]

I created a subform and it works....thanks....

Try the form's "current" event instead.

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

I tried this, but the records did not change in the text fields. I have the
control source for the text fields set as fields in the query that the combo
box is a criteria in.

Thanks....

Put the combo box in the header of the form and make sure the reference of
the combo name is in the criteria of the query. The query is the source of
the form.

In the "after update" event of the combo try

[forms]![form name].requery

to change the records.

I hope that is clear

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I have a form that when a combo box is selected, the result is used as a
criteria in a query. The query then displays the associated field values
based on the selection of the combo box.

Now, I want the results (as a text box or even subform) from the query to
appear on the same form that has the combo box. I want to see the results
every time I change my selection in the combo box...realtime.

I tried to make the control of the text box a resulting field of the query,
but it gives me #Name?. I also tried to insert a subform, but it does not
refresh when the selection in the combo box is changed.

Help.....please.....