Docmd.Openform (like)

Hello, I have a form and a click event on a field that opens another form based on the Me.DDNo (double format). I need to modify it to open frmPmtProposalALL for taking into account decimals. L...

access

George_Hepworth
Dec 29, 2021
Tony2021 It depends, in part, on the datatype of this field in the table. It is, I understand, a double ( number which includes decimals to a specified precision).

That means Like as an operator is not appropriate. Like is used with Text, or String, values.

You can include any number with 7 as the whole number and ANY decimal amount by using a type conversion function to coerce these values:

DoCmd.OpenForm "frmPmtProposalALL", , , "Clng(DDNo) =" & Me.txtDDNo

should do it. Please try that and report back if it works as required.

George_Hepworth

Silver Contributor

Dec 29, 2021

Tony2021 It depends, in part, on the datatype of this field in the table. It is, I understand, a double ( number which includes decimals to a specified precision).

That means Like as an operator is not appropriate. Like is used with Text, or String, values.

You can include any number with 7 as the whole number and ANY decimal amount by using a type conversion function to coerce these values:

DoCmd.OpenForm "frmPmtProposalALL", , , "Clng(DDNo) =" & Me.txtDDNo

should do it. Please try that and report back if it works as required.