Recent content by dfwelch

I had already tossed in the quotes and it works. Thanks!

I want to change the Row Source of a pull-down list based on the value selected in another field on the form. There will be only two possibilities. I have 2 tables (SCA and SOC) containing the values I want in both cases. I am writing a VB procedure to run at the OnExit event for the later...

I now have it as: If Forms!Form1!Frame10 = 1 Then Me.REFNUM1.RowSource = SCA Else Me.REFNUM1.RowSource = SOC End If where SCA and SOC are the names of the two tables containing the sources. It does not work, but also does not give an error as written.

I want to change the Row Source of a pull-down list based on the value selected in another field on the form. There will be only two possibilities. I can create tables (table1 and table2) containing the values I want in both cases. I am writing a VB procedure to run at the OnExit event for the...

Sorry for the delay in response. I just got back from vacation. What I meant by double click deal is when I double click any part of the Yes/No field, the field value is reset to Null (no answer). Follow these steps to accomplish this: 1. Go to the properties of the field. 2. Click the Event...

Yup, wish I had thought about that button idea before I had done this one. Too late now, survey's mailed tomorrow, so this thing needs to be ready to go.

Thanks for the encouragement. Yeah, I considered that about the checkbox. But, my brainless supervisor figures it would be nice to track the the questions that had not been answered, and the actual survey was designed with Yes/No fill-in-the-dots, so I didn't have much choice. Any suggestions on...

Hey guys, in my defense, I have broken the form up using a tab control. We're talking about a four-page fringe benefit survey data entry form. So, I have a 4-tab control on the form. The thing is, about 50 of the 60 questions on the survey are Yes/No. I used radio buttons, which uses two...

I am using a tab form for just about the entire form. I didn't know that it was considered separate from the primary form in terms of counting the controls. I just tested it, and son-of-a-gun, it is! Cool, lemme see what I can do about that!

I have a data-entry form that I set up using the onEnter and onExit events to change the color of the question with the users focus is on the field for an answer, often a Yes/No combo. The problem now is that I have reached the limit for the number of controls on a form, and I am having to...

Yeah, that didn't help.

That's what I will try now. I have compacted it, as this i the front end that I have to share with 3 other people, but not since I started getting this message. In case this does not help, what can you tell me about the solution of putting some of the control on a subform within the form...

So, can someone tell me what the story is here? I remember reading somewhere that you can only put a certain number of controls on a form, but I can't find it anymore. I've done the "rename the form" trick and I've REALLY reached the limit. So, what are my options? I also tried creating a...

I am not sure if this can be done, but I'll toss it out there as a question anyhow. I have a tab control on my form that contains four tabs. In my database, this form will be opened from two different forms. I would like to have the tab that is first active on the form be the second tab when it...

Which form event would I need to modify so that the code occurs whenever the form closes or changes to another record?