Search results

As ever Bob - Brilliant. I now works without the kludge - and makes it easier to document. Thanks once again.

I've solved it with a bit of a kludge - I have an invisible unbound text box that I use to change focus. Is there another more elegant way of doing this?

I was gradually beginning to realize that. Thanks. I will work on this some more.

I'm trying to enable/disable text boxes in a subform with a command button on the subform. The initial condition is Disabled. Thus one click should enable the textbox and the next click should disable it. I used this format for the code from an earlier post of mine: If...

CompaId is text, but I added DISTINCT to the above and bingo! It all works. Thanks very much to both of you.

After checking on "grouping" queries I have the following in an unbound combox for ContactID. This RowSource is actually created when the After_Update code on the CompanyID box fires: cboContactID.RowSource = "SELECT DISTINCT qryTransactions.ContactID, qryTransactions.FIRSTNAME...

The only fields I have selected from the Contact table are ContactID, First Name and Last Name. What is a grouping query?

I have that on the Companies combo. I tried it on the Contacts combo - no joy.

Once I get this solved I will have all my forms set up! Yippeee! Thanks for all your help and patience. I am using Access 2003. My 4 main tables are one to many - Companies->Contacts->Transactions->Sites. I have one other table, OurInfo, that has a one to many relationship with Transactions...

Good idea - tried it and I still couldn't get it to work. After an hour of various combinations using your testing approach the following works: Forms!NameofMainForm.NameofSubformContainer.Form.NameofControlonSubform.Value = Null (or whatever) Sometime just having a sounding board is enough...

I already had before I posted this - that's the link I referred to.

This is probably another easy fix (I hope). I want to be able to clear fields on a subform using a command button on the main form. The combobox (cboTransactionID) is on a subform control(ctlTrnxsSub ). I used a different name for the control and the subform so I know which is which). The...

Sorry - I guess I wasn't clear on my question. But I have figured out my own answer. Thanks for your help.

BTW - thanks for replying - your method worked like a charm This eliminates the need to click on the second box to see the results after a selection is made from the first combo, if the second box is a combo box. How do I do this with a second box that is a list box? Obviously there is a...

Last question (at least for now) - how do I do it with a listbox?

I have my combo boxes and text boxes all tied in and working (thanks to Bob and Paul). Right now, in order to see the results of the first combo box selection in the second box, I have to manually click on the second box. Is there a way to have the list show up automatically (I'm sure there...

I dropped the .value and stepped through the procedure again. Same error. Then I used copy and paste to make sure the references were correct. A typo of some sort must have crept in. The greatest gifts to programmers from Microsoft? Copy/paste and undo. Thank you Access gods and goddesses!

The spacing is one of those forum things. It is correctly spelled in the procedure. And yes the default value is set to Y. I just want to change it to N when there is a need for a different mailing address. I get an error message : Run-time error '2465' Application-defined or object-defined...

I am using Access 2003. I have a command button on a sub form that I want to use to change the value of a text box. The main form is frmAddCompanies. The sub form is frmAddCompaniesSub. The command button I am using is cmdADDNewContactMailing. The text box I want to change is...

I am not bumping this for new information. This is just to say thanks for an effective search engine. And yes I really do use it before I post any new questions! Thank you again - Bob.