I have created many forms for a data entry system and on the second
form I have a text box that has a text box on the first form as its
control source. This seems to be working fine, the data from the text
box on the first form is showing in the text box on the second form.
My problem is that I want the data that is showing in the text box on
the second form to record into a field on the second form, not just
display the data as it is doing now.
I am sure this is a pretty basic problem and coould be easily fixed
although i am a very new user of access and am feeling rather
clueless!! So any basic easy to follow help would be most
appreciated!!

Thans in advance (=

Sounds like you've got programming experience, but not Access experience.

Using the Properties box:
1) Select the form, then in P-box's Data tab, set the Record Source to
the table you want to modify. (Record Source is the top row on that tab)
2) Select the text box. In the Properties box, Data tab, set the text
box's Control Source to the field to be modified. If you've done #1
first, the field is available to you on a picklist.

That's all. Any changes to the text box are fed directly to the form's
record source as soon as you move to a new record on the form (use the
forward and back controls at the form's bottom). Verify by having a
look at the table.

You'll see that as long as the form's Record Source is a table or an
updatable query, you can update nearly any field, and add and delete
records.

Bruce Pick
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++
To send email, remove all < > and [ ] and the [~] between:
[brucepick1]
< a~t >
[comcast.net]


Mel wrote: