Search results

Thank you Bob and Paul for your efforts. I did not abandon this - I simply had other work to do. As you may have gathered I am on a ferociously flat learning curve. After numerous tries I was still having problems. Then I created a new blank db (again), imported everything and for good...

I should have added that I am trying this in the full db - not the sample.

Nice to see you back Bob - I've missed your answers. And I like your site too. When are you going to set up a training course for neophytes like me? However WRT: Me.cboContactID.RowSource = "SELECT tblContacts.ContactID, tblContacts.CompanyID, [LASTNAME] & ', ' & [FIRSTNAME] AS Contact " & _...

OK I thought you were highlighting what you wanted me to change to, not change from. This is going to sound thick, but for tablename I use the query name, and for fieldname, I use the name in the query NOT the name of the control, right? I now have: Me.cboContactID.RowSource = "SELECT...

I did thusly: Private Sub cboCompanyID_AfterUpdate() Me.cboContactID.RowSource = "SELECT ContactID FROM" & _ " cboContactID WHERE CompanyID = " & Me.cboCompanyID & _ " ORDER BY cboContactID" End Sub See if you can open the converted version.

Am I that predictable? Or are you that bored? I will have to surprise you one day and figure this out for myself. Out of curiosity has Access2007 made it any easier to create cascading combos? I am attaching what I currently have because I don't see where the error is.

Wow that was fast. Were you just waiting for me? I also looked at your example from other posts. I took out the requery. The SQL (from the query) is SELECT tblCompanies.CompanyID,tblContacts.ContactID FROM tblCompanies INER JOIN tblContacts ON tblCompanies.CompanyID = tblContacts.CompanyID...

I have looked at the Microsoft site and various examples in the forum. There seems to be a couple of approaches. I just want to make sure I understand how to do this. I have two tables with a one-to-many relationship - tblCompanies and tblContacts. I want to use a bound form tied to a query -...

Sorry - missed that. That worked. Thank you. Now the question is why?

I know. In the same db I got the code to work on a blank form. Some of the other things I have done is create a blank form and copy and paste the text boxes etc. Same problem - it doesn't work. I have also tried different ways of referencing the text box as per Luddite Lad's reference page...

I tried Paul's code as well. I couldn't get it to work on a blank form. But I would still like to get the control working on this form. Any ideas about why it won't work?

Thanks for the reference. I've seen it before - I just couldn't remember where. Your code works fine on a blank database, but just not mine. I have attached a copy to see if you can see where the problem is.

I think the issue is the command button and text boxes are on a subform. I will check that syntax in the morning. Enjoy the holiday!

Neither worked. One question - does vba require an else to an if then statement? As in Luddite Lad's example? I know Pascal (the programming language - not the mathmatician) didn't.

I am getting too sleepy to concentrate on this. I have been wandering around here and on Google for awhile. I have a main form frmCompaniesMain and sub form frmContactsSub On the subform there are several text boxes disabled. They only need to be enabled when the command button...

Sorry to be so long getting back to you on this - the problem is I wouldn't know how to alter the code. Actually I think I may have this in one of the books I've got. If I find it I will post it.

I looked at that one - it doesn't have the wrapping effect. Mainly I want to avoid the "You cant go to the specified record" message.

I seem to recall code that allows Next and Previous buttons to wrap around the "top" and "bottom" of a record set. So that if you are at the first record, Previous will wrap to the last record and if you are at the last record Next will wrap to the first one. I have tried the usual suspects...

Isn't that what setting the visibility property to no does?

I did search and I read that thread. In fact I kept a copy of the sample for future reference. Once this database goes on the network it might be necessary to have a password. But what I need right now doesn't require a password. However inelegant my solution is - it does what I need. Thanks...