How to auto fill controls with combobox

[arnelgp]

if you have Join in your query, Right click on the Line connecting your tables.
the choose "include all records from [payment table] and only those records from [other table]..."
that will make your query Updatable.

Inner Join will make your query non-updateable.

 

[Gasman]

column(1) is for the MOP ie Cash, GCash, Bank, Check
column(2) is for the bank account number
column(3) is for the bank account name..

So you assign ONE column value to each of the controls?, not all three to cone control , even if you could do it as you have written.
If for some strange reason you did want all three in one control, you would concatenate them with & and some sort of separator.

I think having looked again, you are showing all three, but not using code tags to give some decent separation.
If as @arnelgp suspects, you have a continuous form, then likely that will not work. Could use a datasheet instead?

 

[moi]

if you have Join in your query, Right click on the Line connecting your tables.
the choose "include all records from [payment table] and only those records from [other table]..."
that will make your query Updatable.

Inner Join will make your query non-updateable.

let me try that tom, i have had enough for today..

 

[Gasman]

column(1) is for the MOP ie Cash, GCash, Bank, Check
column(2) is for the bank account number
column(3) is for the bank account name..

You canot use that syntax as a control source.
Set it in an event

Me.txtDate = Me.cboDates.Column(1)

 

[moi]

You canot use that syntax as a control source.
Set it in an event

Me.txtDate = Me.cboDates.Column(1)

Hi can you pls expand to where should i put that code? And since i have 3 controls to fill, should i create 3 txtboxes with 3 different column assignment?

 

[Gasman]

I would probably put it in the afterupdate event of your combo.
As you have 3 controls to fill, then you would have 3 textboxes? Those controls should be unbound I would have thought, as they are for display only?
If you want, you could just have one and concatenate them into one, but I would have thought 3 would be easier to understand for the user?

 

[moi]

I would probably put it in the afterupdate event of your combo.
As you have 3 controls to fill, then you would have 3 textboxes? Those controls should be unbound I would have thought, as they are for display only?
If you want, you could just have one and concatenate them into one, but I would have thought 3 would be easier to understand for the user?

hi gasman,
ok can you pls put that in code how these 3 controls look like on afterupdate event pls..

 

[Gasman]

Just as I have written above. That came from one of my controls.

 

[moi]

Just as I have written above. That cam from one of my controls.

Thank you..