Recent content by nag9127

You guys are smart and I feel like an idiot/moron. I had remarked out the line in the Double Click event when I was trying to isloate the code for testing/editing purposes and I never did away with the remark! I used all your responses to resolve the issue and it works properly now. I left the...

TheAceMan1... I understand your point about the object and changing it to a variable will definitely eliminate the error message. But I need to get that value back into the active control of the form from where the modal form was called up with the double click. So I need some link...

I have a line in the Close event of a modal pop up form which is designed to send a value to the control in the form from which the modal form pops up. The modal form is called up via the On_Click event of that control. The line in the Close event of the modal form that is creating the problem...

Thanks to everyone for all the insight in the responses to my original post. You have provided several different angles, legal and otherwise, for me to consider.

If there is another forum where this would be more appropriately posted please let me know. I am working as an independent contractor under an annually renewing services contract. I do all the IT work for this company which involves machine configuration, network configuration and security...

Well, I got it to work by using the value method which I hadn't considered. I also took the DLookup parameter out of the control source for the field and stuck it in the After Update event of the second combo box. Taking the Dlookup out of the field control source property and using the value...

None of these approaches seem to work. And Access 2000 doesn't appear to support recalc as a method. I just don't understand how the second combo field can requery successfully to a blank field after the first combo box is modified from a prior selection (there is a me.combo2.requery statement...

That is an approach I have tried. When I apply that code, I get an error that says "I can't assign a value to that object". Even if I use a variable to accomplish that, rather than assigning the value directly, I get the same error.

I have a from which has 2 combo boxes. The list for the second box is dependent upon the first box selection. The combo boxes are working properly. I have an unbound field which performs a DLookup based on the selection in the second combo box. If selections have already been made and the fields...

I'm using DAO. No need to get into the details right now. I am just getting into the nuts and bolts of it today. As my plan becomes more clear, I will share the details with you. I have some reference material that I am looking at and it appears there are several ways to do this, some more...

Then can I bring a record from the recordset into a form for editing by using a combo box looking up the values from the recordset. Is that possible?

Thanks for the info, Ken Reay and Remou! I will do some homework. What about my question about recordsets. Are recordsets limited to step through looping type actions as opposed to random selection from a lookup? I am speaking about recordsets created during an event through a variable with...

As a followup question, is it possible to have a global variable populated with a recordset based on some criteria and then have a form perform a combo box lookup on the contents of the recordset (global variable) or do recordsets not allow this type of action? Are recordsets limited to step...

I'll work on that this morning and report back on any difficulty. Thanks Remou!

I am not sure how to go about this and I'm not sure if I can explain this very clearly either but here goes. I have a table that has item numbers no duplicates and a second table that has item manufacturing templates, of which there can be more than one per item number (one to many...