Problem coding forms to feed tables

[idforgod]

Thanks guys I really appreciate you efforts in finding solution to my question.
I just discovered a simplest way to do that using macro instead of VB codes.

 

[idforgod]

Hello guys am pretty new in access as well as VB.

Please I need help again.

I populated my textboxes in form using [combobox].[column](1) in the control source of each text box and it works like magic but now the problem is that I can't edit that same to inputs remotely.
It seem the combo box deny me access .
Is there anything I can do?

I will appreciate if there is any solution thanks

 

[isladogs]

Two things
1. It might help others reading this thread if you posted how you solved your original problem
2. I'm not quite sure what your new problem is so forgive me if I've misunderstood.
If each of your textboxes are bound to a column from a combo, then you cannot set the value using code or by direct data entry. By binding these to another control you have indeed 'locked them' as the combo value determines the textbox value.

 

[idforgod]

Ok @isladogs I will post the macro when my PC come alive.
But what I want to do is to be able to populate one form through two source, one being combobox and the other from manually entering the value,

Is there any way I can do that?
I really appreciate if anyone can help.

 

[isladogs]

It seems a strange idea to me but one way would be to use an unbound textbox so it could be populated manually.
Then use code similar to this

Private Sub Combo0_AfterUpdate()
If Nz(Me.Text2, "") = "" Then Me.Text2 = Me.Combo0.Column(1)
End Sub

That would update the textbox if it was empty but not if already populated