I
Iceman
My form is backed by a MS Access table containing 358 project records. The
form has a picklist based on the project number field in the table. You
select the project and retrieve it, then fill out information about the
project in the form. My problem is that the picklist starts with record
number 51. Records 1 through 50 are omitted from the picklist for some
reason. It appears that some of the first 50 records contain information
indicating that the form had been completed for that project, so the project
must've been in the picklist as some point in the past. Any ideas on how to
get all the project numbers to appear in the picklist again? Thanks.
form has a picklist based on the project number field in the table. You
select the project and retrieve it, then fill out information about the
project in the form. My problem is that the picklist starts with record
number 51. Records 1 through 50 are omitted from the picklist for some
reason. It appears that some of the first 50 records contain information
indicating that the form had been completed for that project, so the project
must've been in the picklist as some point in the past. Any ideas on how to
get all the project numbers to appear in the picklist again? Thanks.