requery does not return any value.

F

Farooq Sheri

I have Main form LINKSET_INFO (record source is a query qryLINKSET_DPC). It
has an unbounded combobox Combo0 (RowSource is a table). It also has a text
box Text0 (ControlSource is one of the fields in qryLINKSET_DPC). Selecting a
value from this combobox triggers its AfterUpdate method which is supposed to
run a requery on the Main form and return values for the text box, which it
does not. The statements that I have tried to use without succes are:

Form_LINKSET_QUERY.Requery
and
Form_LINKSET_QUERY.Requery

I have set the criteria for the query to select value mathing that of the
combo box. The SQL for the query is given below.

PARAMETERS [Forms]![LINKSET_QUERY]![Combo0] Text ( 255 );
SELECT [DPC-LINKSET].LINKSETNAME, [DPC-LINKSET].ADJDPC
FROM [DPC-LINKSET]
WHERE ((([DPC-LINKSET].LINKSETNAME)=[Forms]![LINKSET_QUERY]![Combo0]));

What guideline should I follow to form the correct statment for Requery. I
have found that all forms of the requery statements do not produce the
results all of the time (even though there is no error with the statements).
 
Top