well first make sure the text box visibility property is set to false
and then onclick event for the check box put this:
if txtboxname.visible = false then
txtboxname.visible = true
else
textboxname.visible = false
end if
that should work..
im trying to filter the form based for records that have a match between the combobox and the field [cost]
any ideas if i am approaching this incorrectly?
-Raz
nope..BUT
you can make an image the background for the button..and you can just have a colored picture be the background
or if you dont care about see'ing the button depress..i use text boxes and mouse overs that change the color of the text as my "buttons" now
*shrugs*
hope that helped =)
im SURE theres a cleaner way to do this..but have you tried..checking for values in the field..and if you get one.. then display the message box?
example:
create an if then statement..
1) check for values..try using IsNull Function ..if it returns true
2) run your macro
3) if it returns false...
im trying to refer to a certain column of data in a combo box as criteria for a filter..cant get it to work ..is this possible? what am i doing wrong..heres what i got so far:
DoCmd.ApplyFilter , "[cbomm].Column(5) = [cost]"
thanks,
Raza
I have an append query that Im getting key validation errors on..in help it suggested I delete the links and then relink..but of course I couldnt find out how in the help system..
any ideas?
nono let me better explain.
I have the form and everything created from this form I run reports and pass a few different values from the form to reports as SEARCH criteria.
does that clear it up at all?
oops I forgot there were multiple sections to this forum..not used to it.. =/
anyway heres what I posted in general:
If I use a listbox on a form as a criteria for a query. How will the query handle the multiple selections possible in a listbox?
Ideally it will filter based on all selections...