Replace a null field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All
Thanking you in advance. I have a form with a field SoldBy which is usually
left empty (as it would often but not always be duplicate data to the
SalesManager filed). On close if the field is empty I would like it to be
replaced with the SalesManager field. Can anyone please help me with my
dilema. Many Many Thanks
 
You could do this in the form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Len(Me.SoldBy.Value & "") = 0 Then Me.SoldBy.Value = _
Me.SalesManager.Value
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count null fields 4
Find/Replace an empty field 2
Replace "assign the null value" message 1
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Canon IP 6600D Photo Printer 2
VBA catch nonull empty field? 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Concatenation when some fields are null. 3

Back
Top