Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JDK9AB

    Control Source Question

    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...
  2. JDK9AB

    Control Source Question

    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...
  3. JDK9AB

    Control Source Question

    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...
  4. JDK9AB

    Control Source Question

    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
  5. JDK9AB

    Control Source Question

    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...
  6. JDK9AB

    Control Source Question

    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...
  7. JDK9AB

    Control Source Question

    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)...
  8. JDK9AB

    Recieve selected text from combo box in form

    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]
  9. JDK9AB

    Recieve selected text from combo box in form

    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...

Part and Inventory Search

Back
Top