Record Selector to Skip Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am working on Access 2003; on one form name (frmMainRecLog), I place
a text box name (txtRecLog3) which calculates the sum from two text boxes on
the same form. I greatly appreciate your help with writing the codes to have
the form not show a record when the users navigate with the record selector,
if the sum of text box (txtRecLog3) equal zero.
 
If I understand the question correctly, you could base the form on a query.
If txtRecLog3 is an unbound text box for a calculation, you could add a
calculated field to the query, in which you would perform the calculation
that produces the result in txtRecLog3. Maybe something like:
Log3Sum: [Log1] + [Log2]
where Log1 and Log2 are the fields bound to the text boxes to which you
referred. You could use Log3Sum as the control source for txtRecLog3, but
in any case you could set the criteria for Log3Sum (in the criteria row in
query design view) to: >0
 
Back
Top