Recent content by EricaP

Hi everyone, So I have a multi-field search form with a tickbox that is tied to 2 queries that is tied to 2 reports. The form works great and I get all the results I want, but my report doesn't display on my monitor, it simply prints up! How can I get it to stop doing this and show only on my...

No no, you were right. I needed the full code and 2 queries. Works like a charm now though :)

Thank you! It turns out all I needed to make it work with the rest of the search form was the Me.OptionalCheckBoxName with a little tweaking in the criteria section of the query. :)

But if I create 2 seperate queries then how do I tie them in to the query that I already have associated with the form? Sorry I'm a real newbie...

If it is ticked, pull a yes If it is not ticked, pull a yes and a no

Sorry if it's not very pretty, I am just kind of teaching myself as I go...

Ok I can change it to a check box, but I still don't know how to make the query work for the check box. I basically used the LIKE function in the Query to get all my other results, I have copied and pasted the SLQ view below. I know it's probably fairly simplistic, but it works well enough...

ok here is a snip I took of my form - maybe this will help...

Hi there, sorry I can't do the whole zip and upload thing from here so I will kiind of sketch it out for you. I have an advanced search form with 3 command buttons at the bottom (search, clear all, and exit) and then a variety of entries the user can make. So, it looks like this: Name: (text...

Hi, I have been trying to get the following to work with no luck: I have created a multi-field search form, and one of the fields on it is an Option Button. This option button I would like to link to a table where the data type in the field is a YES/NO option. So basically, I would like...

Thanks! Cascading Combo boxes is exactly what I want!!

Sorry, this is Access 2010.

Hello Everyone, I am trying to figure out how to limit choices based on a previous choice made in Access. Here is what I mean: I am creating a database that tracks events. Each type of event falls under a specific heading. I have called this HeadingID. There are 24 different Headings...