Table fields not filling in

[jpulliam]

I am knew to Access but here goes. I have created a form and several
tables. There is a table for the form. When you enter the phone number
it shows in the field with the mask just like it is supposed to. It
also show in the customer ID field in just number format, just like it
is suppossed to. The problem is that the cutomer ID field in the table
is never filled in. I'm not sure what I'm supposed to do to have this
happen.

I also have a similar problem with the product fields in the form and
table. The table fills in with just the number in both the productID
field and the Product Description field.

Any help in this matter would greatly help me get on and hopfully
understand what it is I need to do.


Thanks in advance
Jim

 

[Wayne Morgan]

Are the forms pulling data from more than one table using a query or is the
data coming from just one table? What is the Control Source for the controls
that don't write their data to the table? Is the field in the table an
Autonumber field?

 

[Larry Daugherty]

Hi Jim,

First, if you have used any Lookup fields in your table designs, get rid of
them. They could well be a part of the current problems and will surely be
come problems over time. Never use Lookup fields! If getting rid of them
means you have to start over in your design, do it; that will be less costly
than trying to work around them. You may find that most of your problems
are gone with them.

Then, the best way for you to start addressing your current problems is to
do the following in each case where your form and table don't talk to each
other properly, do the following; one at a time:

select the table in the database|tables window.

click the Autoform icon and then answer the questions the wizard asks
including a name for your new form. Make no other changes at this time

Enter several records with your new form.

You should be able to step through the records and see what you've entered.
You should also be able to open the underlying table and see the data.

It seems that you're just getting started with Access, strangely enough,
there is an Access newsgroup gettingstarted. The folks there are more
nimble at resolving beginner questions and by lurking there you'll learn a
lot by seeing the questions that others ask and the way they get resolved.

I recommend that you spend some time in your local Barnes & noble or Borders
bookstores and brows the books on Access. I believe you could benefit from
some selected reading on Access and on relational database design. I would
post a question in gettingstarted like "Book/Study recommendations -
starting in Access and relational database" You'll probably get some good
answers. Also, for getting started you may prefer to look at used books and
older versions. From Access 2.0 onward they have some relevance.

HTH

 

[jpulliam]

Wayne
The forms are pulling the same table. When the phone number field is
filled in the customer ID feild on the form also fills in but does not
fill in on the corresponding table.

The control source is the phone number field.

The feids are not auto number fields.

Thanks



Larry
I have gone and read several books. But any book that doesn't talk
over my head doesn't seem to address this problem. Thanks.

 

[Wayne Morgan]

If the ID field is not an autonumber field, what are you using to fill in
the ID number? You mentioned the control source for the phone number field,
what is the control source for the ID field's control?

 

[jpulliam]

Wayne
The phone number is the the customer ID number without the punctuation
After tabbing out of the phone field the ID field automaticly fills in
but just on the form not in the table. I don,t want people to have t
enter the number twice. The control source is the phone number fiel
for both. I have not been able to figure out how to have the same inf
in more than one field at a time in the table.


1) Type in phone number
2) Tab to next field
3) The Customer ID field is automatically filled in with phone numbe
less the punctuation.

Ji

 

[Wayne Morgan]

If the phone number field is the control source for both textboxes, I assume
you are using the format or input mask option on the "real" phone number to
add the punctuation to that one. If the same field is the control source for
both and it gets filled in with the phone number then how does it fill in on
the form but not in the table? Are you really running 2 fields with the same
information? If so, this is unnecessary. What makes the ID textbox fill in
when you tab out of the phone number field? What happens when the record is
saved? The data won't actually go to the table until the record is saved.

 

[jpulliam]

If the phone number field is the control source for both textboxes,

assume
you are using the format or input mask option on the "real" phon
number to
add the punctuation to that one. If the same field is the contro
source for
both and it gets filled in with the phone number then how does it fil
in on
the form but not in the table?

Thats what I want to know.

Are you really running 2 fields with the same

information? If so, this is unnecessary.

No it's not unnecessary. The people that will use this form need to se
both feilds as separate items and can not be counted on to fill the
both in on their own.

What makes the ID textbox fill in

when you tab out of the phone number field?

The fact that they both have the same control, I guess. Because if
change that then it won't fill in.

What happens when the record is

saved? The data won't actually go to the table until the record i
saved.


They are not saved to the table ever. at all.

Ji

 

[Wayne Morgan]

I understand that is what you want to know, but you have me a little
confused here. If both controls on the form are being bound to the same
field and the field is filled for the phone number control, then how can it
NOT be filled for the ID control since it is the same field. If you look at
the table and see the phone number field filled in then IT IS filled in. If
there is another field that isn't filled in that is supposed to have the ID
control, then they are NOT bound to the same field.

 

[jpulliam]

Wayne
If you are a little confused then I'm way confused. What is bound