Docmd.Openform check

[Locopete99]

Hi Guys,

Can someone check the below?

This is not working for me.

Blanket Agreement Number1 is a text field
Blanket Agreement number is a calculated field.

DoCmd.OpenForm "Frm_RPS001", acNormal, "", "[Blanket Agreement Number1]=" & [Blanket Agreement Number], , acNormal

 

[bob fitz]

Why don't you bind "Agreement Number1" to the calculated field

 

[Locopete99]

I have multiple forms that I want to open this way to make sure that when I open Frm_RPS001 it will show the same blanket agreement number as the blanket agreement number that is currently open on the frm_Shikomiregister.

I based this on the previous code that I used on a previous version

DoCmd.OpenForm "Frm_Reports", acNormal, "", "[Blanket Agreement Number1]=" & [Blanket Agreement Number], , acNormal

I'm not sure that for this use, binding Blanket Agreement Number1 to Blanket Agreement Number is the best option, but I could be wrong.

 

[moke123]

Blanket Agreement Number1 is a text field
Blanket Agreement number is a calculated field.

Shouldnt you have delimiters around [Blanket Agreement Number]?

 

[Locopete99]

I've tried delimiters, but I just get the "Enter Parameter Value" for Blanket Agreement Number

 

[Minty]

Try renaming the control name for [Blanket Agreement Number] to txtBANo then try

DoCmd.OpenForm "Frm_Reports", acNormal, "", "[Blanket Agreement Number1]='" & Me.txtBANo & "'", , acNormal

 

[Locopete99]

I made it work with the following:

"[Blanket Agreement Number1]=" & "'" & [Blanket Agreement Number] & "'"