I really am a newbie in MS Access programming. Firstly, I have a table with "Batch" as a column. Batch refers to year, which may have more than one record with the same Batch. And may also be a new Batch.
I want to create a combo box or a drop down box of this data. If there is a new record with a new "Batch", the data in the drop down box will automatically updated.