Old form, new fields for new table

  • Thread starter Thread starter Data Slave
  • Start date Start date
D

Data Slave

I have a form that has about 135 fields (about 100 are
laid out like a table). I added a table to keep addresses
better organized. How can I add the 5 fields to the form
from that new table without re-doing the whole form. I
thought that using an unbound text box might work but I
can't figure out the expression or whatever it takes.

Can anybody help? Thanks if you can.
 
I have a form that has about 135 fields (about 100 are
laid out like a table).
Click to expand...

I've never needed HALF that many fields in a Table. It sounds like you
may be working backwards, designing your table to fit your form
instead of vice versa. What is the structure of your tables? Do you
have only one table, or related tables?
I added a table to keep addresses
better organized. How can I add the 5 fields to the form
from that new table without re-doing the whole form. I
thought that using an unbound text box might work but I
can't figure out the expression or whatever it takes.
Click to expand...

Unbound text box values aren't stored anywhere. If you entered an
address into such a control it would exist only until you closed or
cleared the form. Not too much use!
 
-----Original Message-----


I've never needed HALF that many fields in a Table. It sounds like you
may be working backwards, designing your table to fit your form
instead of vice versa. What is the structure of your tables? Do you
have only one table, or related tables?
Click to expand...
sad to say, it was originally set up as a one page
form.To change now, after so many records would be
difficult. It is basicly an all-in-one form. it is
designed so that you can rapidly enter data and then use
a command button to print out that selected form as a
reciept. Honestly it works great because time is of the
essence. When you have a customer in front of you, the
last thing you want is to make them wait while you plod
arround multiple screens.
Unbound text box values aren't stored anywhere. If you entered an
address into such a control it would exist only until you closed or
cleared the form. Not too much use!
Click to expand...
Let me clarify, I have the Phone number of the customer
as the index and it is in an auto-fill combo box. It is
in the main table and it links to the table for the
addresses. I want to add the 4 or 5 fields for the
address and customer names to pop up so we won't have to
retype every time. I thought that a text box (unbound?)
could read/display those fields and then be printed as a
part of that invoice form.
 
Back
Top