Select field in combobox

[divaam]

Hello
I have a form name ‘frmentry’ to entry a data to table ‘tblentry’
In the form there are a combobox that list field name table ‘combofield’ and a textbox ‘txtdata’.
When I click the command button I want to update the data in ‘txtdata’ based on the field that I choose in ‘combofield’ to table ‘tblentry’
How I write it in the query?
Thank youuu

 

[theDBguy]

Hi. Are you trying to add a new record?

 

[divaam]

Hi. Are you trying to add a new record?

No, i just update the record in just one field

 

[divaam]

And I just want to update the field when the field is null

 

[Minty]

In the after update event of the combo (assume it called YourCombo you would use something like

If IsNull(Me.txtData) Then Me.txtdata = Me.YourCombo