Form question

[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?

 

[John W. Vinson]

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?

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

 

[robnsd]

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

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.

 

[John W. Vinson]

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.

Please post the SQL of the query.

--

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