Forms and updating tables

[MisterMan]

Hello,

I am currently working on a database for a work project and I am having problems getting a few features that the powers that be want to work. Allow me to say I have zero programming background and I am teaching myself as I go along, so I apologize if I seem like a blooming idiot by asking these questions.
I have a form that is tied to a table. On that form there are 3 areas, the results of which are driven by information entered elswhere on the form. I solved this problem rather easily by using the expression builder within the Control Source area of the form text boxes, but then I noticed that the information that was being generated was not being put into the table.
Upon further fooling around I managed to make the autodate feature they wanted to work and be stored in the table, but the other boxes information is not being stored. Am I missing a step? I currently have the control source as being the field within the table, and the default value area set to the formula (This is what worked for the autodate area), but it is not working at all now.
Any suggestions would be appriciated.
Josh

 

[Gazer44]

May need to look at this in more detail. Post your email address.

 

[MisterMan]

JK_Sager@yahoo.com

Any help would be appriciated.

J

 

[Gazer44]

sorry, can't open as I'm on access 97 and suspect this is either 2000 or XP.

 

[Annelies]

This is exactly the problem I am having.

For example, I want a text field on a form to be based on a formula (in this case, equalling the text in another text field on the form), and I want that value then saved in to a table.

The problem is, setting the DefaultValue to =[FieldIWant] does not work. If I set the ControlSource to =[FieldIWant] it DOES work, but does not then save back to a field in my table.

Any help would be much appreciated!!!

 

[jplum]

Is there some action that the users takes (ex: a button that the users hits) before you want those fields to populate?

Jennifer

 

[Annelies]

I am trying to ultimately achieve that the user selects a value from a drop down box, that then fills in a text field with some text (retrieved from a table based on the drop down box value), which the user can then change.

Then, on the click of the save button (or whatever needs to happen) the text in that text field is saved back into a field in a(nother) table in the database.

Does that make sense? Or does it sound like it's Friday and I've been working on this way too long? *LOL*