Enter a list of numbers

[Dean]

I'm having a bad day. I want for my users to be able to enter a list of
numbers.
The numbers will be 6 digits, no alphas. But i don't know how many numbers
will be entered, from 1 to 20 ish.
They are to be stored with the rest of the details on the form.
What would be the best way to do this?
1 field on the form if so what sort text or list box with no row source, or
a linked subform?
What format restrictions can I put on the entry to ensure they only enter
numbers?

Thanks in advance
Dean

 

[MarkS]

Dean,

If you do not know the amount of numbers to be entered then I would use a
linked Table and a Subform.

In order to ensure the users input numbers only use the Input Mask on the
field

For example:
000000 forces the user to input 6 digits
999999 Digits or spaces required by not compulsory

HTH
Mark

 

[Douglas J. Steele]

Data isn't stored on forms: it's stored in tables. You need a table with a
Long Integer field to hold the numbers. If there can be multiple numbers
associated with the rest of the data on the form, you'll need two tables:
one to hold "the rest of the data", linked to the one that holds the
numbers.

 

[Dean]

Douglas,

Could you help a bit more, as I stated at the begining "I'm having a bad day".
I want
Text field
Supplier

Date/Time

Yes/No
Booking _Form
Untimley_changes

The supplier is a combo box that is inked to the system, he user selects a
name from the dropdown list.
They then enter the date/Time and click the Yes/No as appropriate.
The user should then enter the list of PO numbers into the sub form.

Can you tell me how I can do this?
I am a very basic user.

Thank you.

Dean