P
Pele
Background:
I have a continous form linked to a table and I have 3 combo boxes linked to
fields on the table. The combo boxes are called JOB TITLE, SCHEDULE and
SHIFT. The source for the combo boxes are queries named respectively as
LKUPJOB, LKUPSCHEDULE and LKUPSHIFT. For the three combo boxes listed abpve,
the bound column is the first field of the underlying query and the column
width of the first field is set to 0" (so that the second field of the query
is displayed).
For the LKUPSCHEDULE and LKUPSHIFT queries, the queries are filtered based
on the bound field of the JOB TITLE combo box. The name of the bound field
for the JOB TITLE combo is called Labor_Rate_ID.
Problem:
It seems like the value of the labor-rate_ID in the first record (i.e. first
job title combo) determines the list used by the SCHEDULE and SHIFT
comboboxes. That is, even though the form has lots of records displayed, the
combo boxes for each record don't have a complete list to work with.
Hence, the SCHEDULE and SHIFT combo boxes for some records are showing a
blank.
Can anybody tell me how to get a continous form to refress the list for each
record on the form.
I also don't know whether the Requery command for a macro could work and how
to use it. I think though, that this problem can't be solved by a macro.
Pele
I have a continous form linked to a table and I have 3 combo boxes linked to
fields on the table. The combo boxes are called JOB TITLE, SCHEDULE and
SHIFT. The source for the combo boxes are queries named respectively as
LKUPJOB, LKUPSCHEDULE and LKUPSHIFT. For the three combo boxes listed abpve,
the bound column is the first field of the underlying query and the column
width of the first field is set to 0" (so that the second field of the query
is displayed).
For the LKUPSCHEDULE and LKUPSHIFT queries, the queries are filtered based
on the bound field of the JOB TITLE combo box. The name of the bound field
for the JOB TITLE combo is called Labor_Rate_ID.
Problem:
It seems like the value of the labor-rate_ID in the first record (i.e. first
job title combo) determines the list used by the SCHEDULE and SHIFT
comboboxes. That is, even though the form has lots of records displayed, the
combo boxes for each record don't have a complete list to work with.
Hence, the SCHEDULE and SHIFT combo boxes for some records are showing a
blank.
Can anybody tell me how to get a continous form to refress the list for each
record on the form.
I also don't know whether the Requery command for a macro could work and how
to use it. I think though, that this problem can't be solved by a macro.
Pele