Combo Box not populated in form - Dialog type

[frispee]

Hi,

I have a button in the main form which opens another dialog type form. This form uses some values in the main form to populate its boxes. When this form is in normal type, everything works as it should. However, when I use 'acDialog' to open the form, the form gets opened but the fields are not populated. Could anyone tell what I am doing wrong?

Thanks for your help

 

[vbaInet]

How are you passing criteria to the form?

 

[frispee]

This is one of the If statements that helps populate the dialog type form.:

If Forms!FTAC_frm!Plant_cbx.Value = "Portland, OR" Then
Forms!Overseas_frm!ExpOrigin_tbx.Value = "Clackamas, OR"

Here FTAC_frm is the main form. Also,

DoCmd.OpenForm "Overseas_frm", acNormal, , , , acDialog

is executed before the 'If' statements.

Thanks for your reply

 

[vbaInet]

You should pass the value via OpenArgs instead. Hopefully the following links will help:

http://msdn.microsoft.com/en-us/library/aa213973(v=office.11).aspx
http://www.fmsinc.com/free/NewTips/Access/accesstip13.asp

 

[frispee]

Your reply gave me an idea and I shifted the entire code to the second form's 'on open' event. Everything works as it should. I don't know why I didn't think of this before. Thanks!

 

[vbaInet]

The Load event would be better.

Glad you got it working!