How to get pass the error I get when a field is blank

[beanhead0321]

Hey guys, I don't know how to bypass an error in my code. The code looks like this:

Private Sub Command29_Click()

Dim rstTakeOut As DAO.Recordset

Set rstTakeOut = CurrentDb.OpenRecordset("TakeOut", dbOpenDynaset)

With rstTakeOut
    .AddNew
    .Fields("Date").Value = Text14.Value
    .Fields("WorkName").Value = Combo6.Column(1)
    .Fields("ProductName").Value = Combo9.Column(1)
    .Fields("ProductModel").Value = Combo12.Column(0)
    .Fields("Quantity").Value = Text59.Value
    .Fields("Price").Value = Text24.Value
    .Fields("Unit").Value = Combo12.Column(2)
    .Fields("ProductID").Value = Combo12.Column(3)
    .Fields("JobNumber").Value = Combo57.Column(1)
    .Update
End With

Me.Text59.Value = ""
Me.Combo57.Value = ""
Me.Combo6.Value = ""
Me.Combo9.Value = ""
Me.Combo12.Value = ""

I'm filling in a table using data from the form. The Price from Text24 is automatically filled by a column in combo12. However the problem right now is that my price column is blank in my combo12 (because there is no value in the table that the combo box gets its info from). When I try this code, I get an error because of that. Is there anyway to just have it fill it with nothing when the price value in the original table is blank?

Also a similar question. I have a calculation to subtract two DSum() functions in my VBA code. When one of the DSum() functions return nothing, instead of taking it as a 0, it just straight up doesn't give me an answer. Can I with it be 0 when there is no data found using the criteria for the DSum?

[RuralGuy]

Look into the Nz() function.

[beanhead0321]

So the Nz() function is like this:
Nz(Variant,[value if null])

For me, would it look something like

.Fields("Price") = Nz(Me.Text24.value,"0")

Nz(Application.DSum(something, something, something),"0")

[June7]

The recordset should not have problem taking Null from the textbox control so don't know why this is erroring.

Yes, use Nz function. Example: Nz(DSum(...),0)

Numbers for numeric fields would not be in quotes.

[RuralGuy]

For these two examples you would probably want to supply a numeric 0 rather than a string "0".

[beanhead0321]

so a numeric 0 would just be 0 instead of "0"?

[RuralGuy]

I don't think Access likes to put a Null in a numeric field.

[RuralGuy]

so a numeric 0 would just be 0 instead of "0"?

Bingo! By jove I think you've got it.

[beanhead0321]

Sweet! Thanks a bunch. I'll run it and see how it goes.

[beanhead0321]

I'm getting a data type conversion error when I run this code.

[RuralGuy]

So at least one of the fields *is* a string. What are the DataTypes of the fields?

[beanhead0321]

It's okay. I got everything to work. The Nz function worked beautifully for the DSum functions. I used an IIf for the other one. Thanks for your help!

[RuralGuy]

Great! Thanks for posting back with your success.