Data transferring from a form to the under-lying table

[dkv98446]

I have 2 problems, which I am sure are related, with data transferring
from a form to the under-lying table. Any help you can provide is
appreciated. My knowledge of MS Access is basically self-taught and it has
been a couple of years since I've worked with it so I am sure I have
forgotten something.

I used the Wizard to create a form based on a table. About half of the
form fields are filled in by typing data in them. The values in these fields
populate the table.

The value selected for the following combo-box also populates the
table.

Name
EventId

Control Source
EventId

Row Source
SELECT Events.EventID, Events.EventName, Events.StartDate,
Events.Instructor1, Events.Instructor2 FROM Events WHERE
Events.StartDate>=Date() ORDER BY Events.StartDate, Events.EventName;

Column Count
6

Column Widths
0";2.3";1";1";1";1";1"

The following 3 text boxes based on the above combo-box are populated
on the form, but the values are not transferred to the table.

Name
ClassDate

Control Source
=EventId.column(2)

Name
Instructor#1

Control Source
=EventId.column(3)

Name
Instructor#2

Control Source
=EventId.column(4)



The following text box is also populated on the form, but the value is
not transferred to the table.

Name
BalanceDue

Control Source
=[RegistrationFee]-nz([AmoutPaid])



Any help you can provide is appreciated. My knowledge of MS Access is
basically self-taught and it has been a couple of years since I've worked
with it so I am sure I have forgotten something.

 

[Rick Brandt]

I have 2 problems, which I am sure are related, with data
transferring from a form to the under-lying table. Any help you can
provide is appreciated. My knowledge of MS Access is basically
self-taught and it has been a couple of years since I've worked with
it so I am sure I have forgotten something.

I used the Wizard to create a form based on a table. About half
of the form fields are filled in by typing data in them. The values
in these fields populate the table. [snip]
The following 3 text boxes based on the above combo-box are
populated on the form, but the values are not transferred to the
table. Name
ClassDate

Control Source
=EventId.column(2) [snip]
The following text box is also populated on the form, but the
value is not transferred to the table.

Name
BalanceDue

Control Source
=[RegistrationFee]-nz([AmoutPaid])

Any help you can provide is appreciated. My knowledge of MS
Access is basically self-taught and it has been a couple of years
since I've worked with it so I am sure I have forgotten something.

Simple rule really. For a control to save its value to the underlying table it
must have a control source that is a field name and nothing else but a field
name. Having a field name as a ControlSource literally means "This is where I
get my data and this is where I save my data". If the ControlSource is an
expression then where does the data go and how would Access determine that?
Simply by using the name of the control?

The good news is that since everything you are talking about can be derived from
expressions then you should not be attempting to store them in your table
anyway. There is absolutely no reason to do so and many reasons NOT to do so.

Just remove those fields from your table. You don't need them.