when checkbox is checked then hide data

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

Guest

I have a form where cherry data is gathered from a query. I use this form to
check off if a specific lot of cherries were packed and then number the
running order for the next day. So what I need is if a specific "row in the
form" has been packed and I place a checkmark in the checkbox I don't want
that information to show the next time I open the form. Is this possible and
how? Thanks in advance - Zenia
 
Perhaps a better description of what exactly you are trying to do would
help.

Is this checkbox linked to a database field (i'm guessing it is?) If
so, you can just modify the forms's query to include only rows with the
checked = false right? Ie. "select * from table where IsPacked = 0".

You say you don't want the row to show up the next time you open the
form, and this should do the trick.

- AB
 
this is what I did. I have an append query which then I run to get my append
data. I have a form where I use this information to get a run list. Which
gives me my report of my run lists. I believe I should put this check box in
my form but when I run my aooend query it brings it back. Any ideas how to
make this easier?
 
Back
Top