I have a query which uses a y/n field (check box) in my data base. I've written a form to support the query and want to include the check box. When the check box is not clicked, the record will appear in the query but if the check box is (no) then the record will not appear. The idea is that after the query is run and the customer makes his phone calls, he wants to be able to click the check box and alter it's state to 'yes' so that the record will not appear next time the query is run and he won't make another call to this person.
I've tried to include the check box with the data sourcing the query (didn't work) and also sourcing the table from which the query is drawn (didn't work), whenever I click the check box all I get is a beep and nothing happens.
I would certainly appreciate some help with this, my forehead is getting kinda flat....
Thanks, Samm
I've tried to include the check box with the data sourcing the query (didn't work) and also sourcing the table from which the query is drawn (didn't work), whenever I click the check box all I get is a beep and nothing happens.
I would certainly appreciate some help with this, my forehead is getting kinda flat....
Thanks, Samm