Search results

Instead of making a button, use vba on the form_load and form_current so that every time the form is opened or moved to another record, the calculation is made. Then just refresh the form (or specific field) to show changes. for example Private Sub Form_Current() Me.TextBox1.Value =...

If you're trying to save the data from a form, you probably save it in a table that the form links to. Use the control source of the combo box to link to the table, so the value selected will be stored in the table with all of your other form data. If you want to fill the combo box with...

Why Oh Why? I've been working with Access for 6+ months now and have developed several modules and forms to handle tons of data, now this weekend I have come upon a conundrum that has shaken my faith in the program all together. In the immediate window (or anywhere for that matter such as a...