field list will not update when adding field to table

[TLJ]

I have added a field to a table but it is not listed in my field list on the design view of my form. How do I fix this?

 

[WayneRyan]

TLJ,

If your form is based on the query, just select the new field and
move it down with the others.

If your form is based on the table, then this should not happen.

Wayne

 

[Pat Hartman]

You may have to force Access to refresh the form's fields collection to get it to recognize the new column. To do that, delete the name of the query from the form's recordsource, save the form, then put the queryname back.

 

[TLJ]

Thanks. I went to the form record source property. A field that I had deleted was still listed. I simply typed my new date field name in its place. There it was.

Can I store a calculated control's value on a table. If so how? I have a value from a form that I want in a report, but I don't know how to get it there.

 

[Pat Hartman]

Can I store a calculated control's value on a table. If so how? I have a value from a form that I want in a report, but I don't know how to get it there.

- there's been a rash of questions on this topic recently and the answer is always the same. This is a really bad idea. Recalculate the value in the report. If this is something that you need to do in many places, you can do the calculation in a query and then join to that query to obtain the calculated value. That way you can minimize the locations where a complex calculation is actually performed.

 

[TLJ]

What I have is 4 criteria for each record
I made combo boxes in a sub form with new calculated controls to be = if No then = 0 otherwise, 25. This gives yes and not required choices weights of 25 (percent) each. I used a similiar control for each criteria and then have a calculated control to total the values giving a "percent" value.

The report I have to provide long hand is:

name criteria1 criteria2 criteria3 criteria4 percent compliance

jones no yes not yes 75
smith yes yest not yes 100
brown

 

[TLJ]

What I have is 4 criteria for each record
I made combo boxes in a sub form with new calculated controls to be = if No then = 0 otherwise, 25. This gives yes and not required choices weights of 25 (percent) each. I used a similiar control for each criteria and then have a calculated control to total the values giving a "percent" value.

The report I have to provide long hand is:

name criteria1 criteria2 criteria3 criteria4 percent compliance

jones no yes not yes 75
smith yes yest not yes 100
brown no no yes not 50

I have to show "yes, no, or not required" with a total percentage for each record.

Right now, my subform does this for each record. I have a query to pick these special clients that I do this table on from the rest of my clients. The percent compliance on the table is blank. I don't know how to get my percent compliance to total. in a query. Can I reference the calculated control in my form and place it in the query.

Can you direct me how to do this (in the easiest way) specifically in novice terms?

Thanks to all that has helped me so far. I am supposed to have this in a meeting tomorrow morning.