Me.openargs showing null value

[deepaksharma]

I am attaching a program, in this two forms, one is offer_entry form and the other form is form_offer_register.
When an offer number is double clicked in the form_offer_register, that record opens in the offer_entry form for editing, for this I have coded open arg in the on load event of the offer entry form.


The problem is that open arg coding is showing null value and is not working properly.
Can anyone tell the reason for this?
Thank you.

[Welshgasman]

You have to pass the openargs in on the form open command?

[Bob Fitz]

Try:
DoCmd.OpenForm "Offer_Entery", , , "[OfferNumber] = " & Me.txtOFFERNO, , , "EDIT"

[deepaksharma]

Try:
DoCmd.OpenForm "Offer_Entery", , , "[OfferNumber] = " & Me.txtOFFERNO, , , "EDIT"

Thanks Bob this code is working however the code I put in sometimes worked and sometimes didn't.
Can you tell what is the special difference between these two?
Thanks again.

[deepaksharma]

You have to pass the openargs in on the form open command?

I don't understand what you mean.
thanks for replay.

[Bob Fitz]

Thanks Bob this code is working however the code I put in sometimes worked and sometimes didn't.
Can you tell what is the special difference between these two?
Thanks again.

Your original code opens the form and does filter the records correctly.
However, in the OnOpen event of form Offer_Entery you have code that interrogates the form's OpenArg property and if that property is not = "EDIT", then the code moves to a new record.
The code I offered sets the OpenArg property when the form is opened.

[deepaksharma]

thank you very much bob......