Continuous Form VBA Code - is it possible?

[Mr Retirement]

Hello all!

I have a combobox with a dropdown of information that has multiple columns (from a query). In a normal (single) form, I normal use the 'on change' event and reference the other various columns that wasn't selected to change other text boxes on the form.

For example:

Me.TXTexamplebox1.Value = Me.InitialDropdownSelection.Column(2)
Me.TXTexamplebox2.Value = Me.InitialDropdownSelection.Column(3)

Is something like this possible in a continuous form? How can I code the specific textbox that i'm looking to change? Because as the next record becomes available, I want it only to change that text box on change... not all of the text boxes.

Hopefully this makes sense - a little hard to explain.

Any advice is appreciated!!!

Thanks,
Mr R

 

[Mr Retirement]

Apologies... it works the exact same way - not sure why it wasn't working earlier... but I guess it is solved haha

 

[Micron]

Not sure if you realize this or if it even matters, but FYI - the change event happens every time you type a character in a control that has that event. Perhaps also might be helpful to point out that if your post refers to a single field (aka a specific control on a form) and that form is a continuous form, there is only 1 of any such control. Every instance of that control that you see in the records is just a copy of it. If it is bound, Access will distinguish one from the other. If it is not, whatever you do to it (data-wise) will propagate to all the copies. That includes some other things as well, such as some properties (conditional formatting is another matter). You show textbox1 and textbox2 but don't say if they represent one field or each one is bound to a different field. I have to presume the latter since you seem to have arrived at a solution. You might want to consider using a different event - say, AfterUpdate. I'm fairly certain that the change event will also fire after you have made a list selection, but as I noted, it will also fire on almost every keystroke if you type into it.