Option Buttons

[GinaWhipp]

In order for this to work you have to reference the column in the List Box which is the Row Source of the Query and match it to the Option Group. That said I suppose I could make it work but what sense does that make not being able to show you the correct way to do it? You say you want to learn... then let's learn the correct way.

 

[Infinite]

Ok, in the current data base, it is all (should be) fixed. If there are any OTHER problems, let me know, cuase I got a data base from...Cant remember who atm, but it checks my data base and tells me what I have wrong, so I fixed almost all of it. Cant fix anything to do with some of them, because thats how I have to import them. Other wise, thanks!

 

[GinaWhipp]

I tried to do this via VBA but that would mean redoing your query and that was way more then I had time for. So, I opted to adjust qryItems. You will need to create a button to *Clear the Filter* because unless you clear the Frame you will not be able to see all the records. I'm going to also suggest you start using a Naming Convention to avoid confusion later on.

You still need to go thru the Tables and fix the Reserved Words used.

 

[Infinite]

Thats just what I wanted, thank you very much!

 

[GinaWhipp]

You're welcome...

 

[Infinite]

Question, I am trying to figure out how you did this. I can work with it, but I would like to know how, I saw you had the the Field called

[Forms]![frmItems]![Frame16]

and its criteria was "Is Null" and you have the other field "StatusID: Status" and its criteria is

[Forms]![frmItems]![Frame16]

But, when I tried to do it (lets say with Frame17) and do the whole "Is Null" and the Forms!Table!Frame! It doesnt work for me.

FYI: The field is the field "Category"

 

[GinaWhipp]

The StatusID field which you had in there (or I would have put it in, is numeric which matches the Option Group choices. So, numeric to numeric. I don't know what Category is but if it's text then it won't work.

The item you are calling a Field is actually a Control on your Form. It's you Option Group. (Just another reason to give Controls *real names*.