Controlling a form in vba

[ZMAN2]

Using VBA...

How do I test for a particular open form?

Then

If open, populate a field on that form.

Actually, I don't even need to test if it's open. I just need to populate that field on the form.

DoCmd.Forms!myform![field1] = 1000

I tried using me, but its outside of the form class and it doesn't exist. How do you control a form from another module. I searched and found that it must be declared, but there were limited examples. I need more help than what I came accross.

Thanks in advance

 

[RuralGuy]

The form *must* be open and you need to go through the Forms collection:
Forms!YourFormName!YourControlName = 1000
...using your names of course.

 

[ZMAN2]

Thanks

Thanks Rural Guy! I could have sworn that I tried that exact same code and it didn't work What a noob!

Thanks again.

 

[RuralGuy]

Glad I could help.

 

[Banaticus]

How do you test to see if the other form is open?

 

[RuralGuy]

Hi Banaticus,
Please start a new thread with your question.