Search results for query: *

Well Jeff, it turns out it was that simple. That was the first thing I had tried before, but unfortunately I got errors each time. Now it worked for me. I can't explain it, but thanks. Bob, I wanted to thank you for the time and effort in trying to answer my question. It was very much...

I think we're not communicating properly. Let me add to the problem to show you why your solution, which will work in some cases, doesn't apply here. Depending on the two list box entries, they will need to be displayed in one of 13 different text boxes. In addition to that, there can be...

Of course the control source works if you just type it in. However, what I have run in to is setting the control source using VBA because the row I need out of the list boxes varies. Since the control source contains quotes, when you store the string in VBA, it stores it without the quotes...

Both list boxes are have a multi select set to none. I don't set a row source indicator for the any of the boxes. They all have a row source type of value list. Both list boxes only have 1 column. Thanks. Justin

Ok, lets just forget about the i. Obiously the rows defining the textbox are going to change. If they were going to stay the same, I wouldn't have to worry about using VBA for this issue. However, this is not the problem I'm trying to solve. My problem is how to get the two values in the...

This is a small piece of a huge form, so I appologize if I haven't been specific enough. Here is the general setup of the 3 items. The two list boxes are next to each other on my main form. They are populated by values input in another small form. Once the main form is complete, I click a...

I have two list boxes and one text box. In general, I would like to set the control source of the text box as: form.text1.controlsource = form.list1.column(0,i) & " - " &_ form.list1.column(0,i) i is a variable determined by a loop. If list1.column(0,1) = read and list2.column(0,1)...

Sorry to everyone who had to read this, I was just not using my brain. I kept trying to view it as a variable in VBA instead of as a form entry. In the control source on the textboxes in the form, I was typing Forms!ScheduleReport!combo50.Text instead of [Forms]![ScheduleReport]![combo50]

I created a form for my users to use. Now they need that form exported to word just as it appears on the screen. Obviously the only way to do that is to make a report from it and export the report. So I am trying to pull the selected values from my combo boxes in the form to a text box or...