what's the diff?
- Thread starter skate
- Start date
David R
I know a few things...
- Local time
- Today, 04:16
- Joined
- Oct 23, 2001
- Messages
- 2,633
That depends on your intention. Current is a good event for scrolling through records. AfterUpdate is a good one for after you change a combobox or text box.
Load should probably not be for putting data in a specific record on the form, because what will happen when you switch records? (unless you've blocked that possibility for the user).
Depending on what you're trying to do, you may not need any code at all. Can you give an example/be more descriptive?
Load should probably not be for putting data in a specific record on the form, because what will happen when you switch records? (unless you've blocked that possibility for the user).
Depending on what you're trying to do, you may not need any code at all. Can you give an example/be more descriptive?
Last edited:
- Local time
- Today, 05:16
- Joined
- Feb 19, 2002
- Messages
- 47,102
If you want to display a column of the combo in a separate textbox, you need the code in two places (or one place and execute it twice). It needs to be in the Current event because that event fires every time a new record is displayed on the form and it needs to go into the AfterUpdate event of the combobox because that event is fired after the combo is changed. Any other place is unnecessary.
David R
I know a few things...
- Local time
- Today, 04:16
- Joined
- Oct 23, 2001
- Messages
- 2,633
And you only need the code if you're actually _storing_ the extra column from the combo box. If you're just displaying it, set the control source of the text box = ComboName.Column(x) (for some reason, you have to leave off the Me. part).
Actually having store the extra column is relatively rare, and should only be done when you cannot rely on being able to go back to it later and it having the same value. Price information is a good example of this.
Actually having store the extra column is relatively rare, and should only be done when you cannot rely on being able to go back to it later and it having the same value. Price information is a good example of this.
Similar threads
