Recent content by SnayJ

You're missing the Cond code... but I think I get what you did. I'll try to follow the directions you pointed to. Thanks!

I need to write the query for the dropdown based on the EBAY Category ID.... so if I query for Category ID 268 it would give me for the dropdown: Brand New Like New Very Good Good Acceptable And if I query for Category ID 288 it would give me: New with tags New without Tags New with Defects...

Right but the primary key is the EBAY Category ID... so shouldn't result in an integrity issue (Indexed Duplicates OK). Right?

Sorry Skip... Microsoft Access: [268] | [1000] | [Brand New] | [2750] | [Like New] | [4000] | [Very Good] | [5000] | [Good] | [6000] | [Acceptable] [279] | [1000] | [Brand New] | [2750] | [Like New] | [4000] | [Very Good] | [5000] | [Good] | [6000] | [Acceptable] [280] | [1000] | [Brand New] |...

Ok so I am making a DB to manage my Ebay Inventory. One of the tables is EBAYCONDtbl, which keeps the applicable condition options which correspond to a Ebay Category ID. So basically like Mens Shirts have a particular set of possible conditions and Womens shoes would have a different set...

I didn't know the subs loaded first... thought the main did. I have some parts to the subs that require items on the main, might be the problem. I'll check and get back here with what you asked for... might be tomorrow. Thanks for your help.

I tried it, didn't get it to work. I opened the form acNormal, and put the code as you wrote it... didn't work. I changed some of the names to match my stuff... MAINfrm, ITEMID, CURRENTITEM and it still didn't work. I placed the code on the Open Event... and nothing would happen. I put it on...

Ok... bare with me (I'm not trying to be argumentative), I learned coding thru trial/error and forums....no classes so I'm very poorly self-taught. But I think the way you are telling me to do it is assuming I'm using Master/Child linking for the Main/Subforms... and I'm not. I've never done...

I can't use the On_Open Event on the main or subform because when that form usually would open I wouldn't want it to do anything. Unless I was to declare a Global Variable that I could set on the other form and check for that Global Variable on the On_Open Event. And run it that way... I just...

MajP, I know how I would handle this if I was using a listbox, but if you remember I went with the continuous subform so I could conditional format the records based on criteria. Well, now I want to be able to (from a different from), bring up this form and cycle thru the records till I'm at...

MajP, Appreciate that much!

MajP, Great explanation, thanks a bunch. I really wish I could have more formal training in all this. I took a VB class in 1998 and then from there have learned by Tek-Tips and trial/error. I make pretty decent simple databases. My more complicated ones give me a headache... but I enjoy the...

MajP, Appreciate the link to that... not exactly sure if it will help... but I'm going to try it. I do have another question that might be easy for you... I want to filter the subform by clicking a label on the parent form. How can I affect the subforms rowsource. I tried: The label is on...

MajP, What I meant is the Mouse Wheel doesn't work (Hover and Scroll). I did fix the whole disappearing text issue. I simply setfocus to the visible textbox when I click on the colored textbox. It highlights the text, but that's fine. I checked the subform cycle and it's set to All...

Appreciate it, this did work but it presents another problem. When I'm clicking around on that continuous form now, when I click on the textbox that changes color, the text I'm viewing in the fields above it disappear. I've tried changing the enabled/locked values for the colored text box...