11

Access the VBA code to copy information from a combobox and paste it into a text...

 3 years ago
source link: https://www.codesd.com/item/access-the-vba-code-to-copy-information-from-a-combobox-and-paste-it-into-a-text-box-on-a-continuous-form.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

Access the VBA code to copy information from a combobox and paste it into a text box on a continuous form

advertisements

Really need help with this, I have a continuous form with a combo box to choose data, each row has a different criteria and you can choose only certain items per row in the combo box drop down. (As an example I have four rows one is a cap, one is a bottle, one is a label and the last is oil to go in the bottle.)

What I need is when I have chosen something in the combo box drop down I want it to paste into a text box and stay there until another choice on the same row is made...... Currently I can make the information appear in the textbox but then when I move to another row and choose anothe item it over writes anything I have already chosen.

So an example would be I have chosen product 1, it has cap 1, bottle 1, label 1 and oil 1. In the drop down combo box I can choose only bottles to replace bottles caps to replace caps and so on. I want to choose bottle 2 in the combo box on the bottle line (Which changes all the combo boxes) I now want to save that choice in the text box on the bottle row only, then when I choose Label 2 on the label row even though it changes all the combo boxes I don't want it to overwrite the text box for the bottle row. (I'm assuming a criteria that will only change the row of the combo box you are clicking on or something like that)

hope this makes sense to every body (P.S. I don't know how to get a screen shot in here so have tried to explain to the best of my ability)

Many thanks

Justin


You have to bind the textbox to a field in the record.

As long as the textbox is unbound, it doesn't know about a record and will display the same for all records.


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK