Form bound to query

[dimitri]

Hello,

I am able to bind the Form to a simple select query ( Thanks Bob Larson ). Then the textboxes control sources are set to some of the fields from the query. I am also able to traverse the Next and Prev (DoCmd.RunCommand acCmdRecordsGoToPrevious) records using the buttons. The question now is,

If TextBox A which is bound to Column A has a null value the condition is to populate TextBox A with Column F of the query. How can I do this ?

Thank you

 

[boblarson]

In the On Current event do this:

If Len(Me.TextBoxANameHere & vbNullString) = 0 Then
   Me.TextBoxANameHere = Me!ColumnFNameHere  ' note my use of the bang
End If