select multiple data from a form

[Dire straits]

Hi All,
I have created despatch software for my small business. I manufacture ten
different products. Every product that is manufactured is given a serial
number. At one time all serial numbers started from 1. I want to log all
dispatches that take place. I have created a database where all transactions
will be recorded. Using a data entry form I am able to input products
shipped. I have also created a table with all serial numbers. I would like
to open this table and tick the serial numbers that are being dispatched
against the product. This is very similar to a pop up ‘Calendar’. The only
difference is that I would like to select multiple serial numbers and then
update the despatch record.
I am sure that for you all this is easy as. But I am in dire straits and
need help urgently…

 

[Dire straits]

Hi George,
I am very grateful of you taking time out and answering my query. You're
assumptions are correct. To make it user-friendly for the operator to select
the serial numbers, I was hoping to create a form that will list all serial
numbers and a tick box ï’ for yes/no function. All the serial numbers
selected will be assigned to that particular transaction. I will really
appreciate your offer of sending an example.
I will now explain in further detail of the database that I am creating. I
manufacture microphones in Australia and export all around the world. There
are twelve different types. Each and every finished product is assigned a
serial number. I have created database to record all receivables (in) and
dispatches (out). Part of the despatch procedure is recording of the serial
numbers in the database before despatch. As mentioned before that all serial
numbers started from 1. Currently, the serial numbers are entered manually.
I would like to create a form that is opened and all available serial numbers
are listed in the form. The serial numbers can be selected by ticking the
box opposite the serial numbers. This method can be a time saver as it will
eliminate manual data entry and multiple serial numbers can be selected by
using mouse.
I will be really grateful for any help that you can provide.
Thanks again,
Dire Straits.