Recent content by kmb

Just so anyone that looks knows...I figured out a solution...although it may be a workaround...I won't be the judge;) I included the following two lines of code into the gotFocus event of both combos on the subform and on all navigation buttons. Me.OrgNameCombo.Requery Me.OrgNameCombo =...

Hi all, This is kind of a two parter... Explanation: I have an unbound combo box (organization) that's rowsource is a query where another combo (contact) on the form supplies a parameter. The query works correctly. Problem 1: I would like to display the first value from the combo's list. I...

Thats if you are assuming that armageddon is a destruction event and not more of a "restructuring" event. I am not overly religious about this, I just think that doomsday scenarios are overplayed.

Consider this....maybe the climatic change is a shift in how we live...maybe we are going back to the dark ages...I see any "armageddon" as a change, not an end.

I know its been a while since the last post, but I just wanted to say thanks for those who had input here. I would also like to note that thanks to the many kind people here and around the net, that my first real dB is becoming a success. It is mostly normalized and I have learned a lot...

I lived in SC for a while and the locals were the same way!! Even in Columbus OH where it snows a little bit every year, if there is 3-4 inches on the ground, they close down all the roads and you can get a ticket for driving, even if your are like me and have studded snow tires because when it...

Anybody seeing snow this week? We are getting pounded. Already have almost a foot and possible 2 feet by tommorow morning. Love that lake effect snow off of Lake Erie (one of the Great Lakes in the US).

Thanks very much. John sorry I hadn't looked at that link, I am going to save that for future reference. Pbaldy thanks for the info, that worked nicely, I didn't even think to try that. Again thanks very much. KMB:)

Pbaldy, I used requerys in the after update event for the combos and I used one in the on current for the form. I made the criteria for Type in the query for the Category combobox as: the Combobox for the Type. KMB

This article isn't specific enough. Thanks very much though. KMB

Hi everybody. Thanks for previous help. I have a new issue that may have an easy fix or it may not...I haven't found it here or on the net. Anyways, the basic idea is that I have 3 cascading combos on a form (Category Type, Category, and Subcategory). When I pick a Type, the correct...

Well....I think I finally may have figured it out. It seems to be working how I want it to now. :) Thanks

Bob, I appreciate your help, but I have tried to strip down my file as much as I can and it is still about 1.2 Mb. If there is another possibility, please let me know. Thanks

Bob, I am using 2003. Thanks. kmb

Hello, I have been searching the net and the forum for a few days trying to come up with an elegant solution. I have figured out, by reading and experimenting with others' ideas on how to make a subform with for a junction table. Thanks Pat Hartman for the example for venues and customers...