VBA code

cmfog

Registered User.
Local time
Yesterday, 18:30
Joined
Jun 18, 2014
Messages
21
I am currently working on a project that was previously started by another individual. I am working in the form and trying to change to the code for the form but I am not sure what to change. As of right now in the form there is a combo box where you can choose from a list of systems, which is linked to a list box with parts that you can choose. Whenever you change the system in the combo box it changes the list box to the parts that go with that system. But I have recently discovered that I need to have all of the parts showing in the list box at once so I deleted the combo box. All of the parts now show up in the list box but when I select parts from all different systems it still only sends the parts from the first system because I believe that it is still linked to the combo box which is initially set to the first system. I am not sure what to change. It might have something to do with the code of the button that sends the selected parts to the report. I can upload my code if need be
 
Instead of a generic post like VBA - create a heading that fits your quetion and category.

The question is one run-on sentence.

Let me suggest this.
A. Know the existing Form and Controls
1. Make a copy of the current project.
2. Open the form.
3. Evaluate the Form's property including Data tab. If the form's data is set to a table, or query understand the data source (e.g. look into the table or query).
4. Evaluate the key controls on the form. Look at thier properties carefully. Pay attention to the Data tab and fields they are linked to.
5. Open the Form's code module. Evaluate and trace back each event to the control.
B. Make a plan as to what will change
1. What needs to go, what needs to be added
2. What properties will be removed, what will they be reassigned to (or new ones entered).

For a complex project, I use SnagIT. There are many competitors, this is not a recommendation. SnagIT allows me to take screen shots of a form in design view includeing the properties. It also allows notes to be created on the screen capture.

Example attached:

Learn how to upload visual examples with your questions. It makes the question more entertaining if anything. ;)
 

Attachments

  • Example of Address Prototype.png
    Example of Address Prototype.png
    99 KB · Views: 59

Users who are viewing this thread

Back
Top Bottom