Form question

  • Thread starter Thread starter robnsd
  • Start date Start date
R

robnsd

I need a form that will update a table. However I only want records
that meet a certain criteria to appear in the form. Those would be
records that greater than a number calculated from several fields in
the table.

How do I make the form only include those records that meet this
criteria and still update the table?
 
I need a form that will update a table. However I only want records
that meet a certain criteria to appear in the form. Those would be
records that greater than a number calculated from several fields in
the table.

How do I make the form only include those records that meet this
criteria and still update the table?
Click to expand...

Create a Query based on the table; include this calculation as a calculated
field in the query. Base the Form on the query; the rest of the fields will be
updateable (unless you're doing totalling or something else which would cause
a record's field values to depend on another record).
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Create a Query based on the table; include this calculation as a calculated
field in the query. Base the Form on the query; the rest of the fields will be
updateable (unless you're doing totalling or something else which would cause
a record's field values to depend on another record).
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.co
Click to expand...

Thank you John for your answer but it is not working. So long as I
have the calculated field my form will not let me input data.
 
Back
Top