updating a table from a form (1 Viewer)

[ANDREW_SAUNDERS]

I have a form developed from an table where the user can input info about dates ie start date of holiday and end date
this will be part of a shift patern cover database

the form also has textboxes where the dates in between these two apear ( via expressions in the scource field)
also it shows the day of the week

I would like to the put these dates back into the original tabel under "hol1" "hol2" etc

am I doing this corectly or is there a better way ?

regards Andrew

 

[KKilfoil]

I think your difficulty is in not specifying the datasource for your form at the time you created it.

Try making another form using the form wizard, and specify the table, and then the fields you need on your form.

You can copy your existing calculated fields to this new form via copy/paste (you may have to fiddle with the names of the text boxes in your formulae afterwards).


By the way, you should almost NEVER have fieldnames like hol1, hol2, etc. This is NOT a normalized structure and will lead to many, many headaches later. You should read http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/office/plan/sysplan/ureldes.asp

 

[ANDREW_SAUNDERS]

hi thanks for the reply

i have already tried this but will have another attempt
Im i corect in putting the calculated fields into the control scource ?
regards Andrew