Input form

[Dave]

I've asked a similar question, but I don't think I was understood.
Probably because I didn't properly know how to explain it. So here's
another try.

I want a form with 10 textboxes numbered 1 through 10 as "Locations".
When somebody enters a name in textbox "1", I want to record in a
table the Location, "1" and the name that was entered. And again if a
name is input into textbox 2, I want to record 2 as the location and
the persons name, and so on. If a textbox is left empty, then nothing
is recorded in the table.

How do I do this? As far as table design and form design?

Thanks for all the help I get here.

Dave B

 

[George Hepworth]

If your table is properly designed, this is a very straightforward task, but
the key is proper table design.

You don't indicate what other fields need to be in this table, so the
following is only a starting point

tblWhatever
=========
WhateverPK -- Primary Key (use Autonumber)
LocationNumber
LocationName
...other fields as required

Create your form in continuous view, not single view. It will have two text
fields, one for the location number and one for the location name.
Generally, if you include a field on the form for the primary key, you can
hide it so the user isn't confused by it.

This allows the form to display from one to any number of records, each of
which shows the corresponding location. As you add additional locations, the
form will expand to accomodate the next location. No need to prenumber the
fields.

 

[Bob L.]

I've asked a similar question, but I don't think I was understood.
Probably because I didn't properly know how to explain it. So here's
another try.

I want a form with 10 textboxes numbered 1 through 10 as "Locations".
When somebody enters a name in textbox "1", I want to record in a
table the Location, "1" and the name that was entered. And again if a
name is input into textbox 2, I want to record 2 as the location and
the persons name, and so on. If a textbox is left empty, then nothing
is recorded in the table.

How do I do this? As far as table design and form design?

Thanks for all the help I get here.

Dave B

Not clear why you are doing it this way. That is, I would think you
would have a table with 2 fields: Location and Name. So a particular
record might have a 1 in the location field and Joe Blow in the Name
field. Next record might be 2, "". etc.

Take a look at help, especially the sample database to see how tables
and forms are designed.

Bob L.