Recent content by Raza

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

im sorry im trying to filter the form based on the selection in the combo

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 =)

try forms![formname]![subformname]![fieldname].setfocus in your onload event for your form didnt test it. might work though lemme know if it doesnt

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

Can you expound a little? Im not sure what you mean by table load orders. Thanks, The Razzzz

update: yup thats what I had to do..now if I could just automate the process =)

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...