Show1 not working in Access

[Windsurfer]

Hi, I hope someone can help me.
My brother(he knows VB, not Access)wrote some code for me:

While gsPassword=""
frmMyForm.Show1
if gsPassword<>"" Then
End If
Wend

When I tried to use it "Show" does not appear as valid.
Can someone help me with a proper way to handle this.
Your help is greatly appreciated,
Emilio

 

[Fornatian]

Having said that your brother knows VB not access is the answer. 'Show' is a word used in VB to show a form. Whereas in Access you have to OPEN the form. The alternative you operation to consider is:

While gsPassword=""
Docmd.OpenForm "frmMyForm"
if gsPassword<>"" Then
End If
Wend

Although I don't know what you are trying to achieve, the above will give you the same result as the Show method in VB.

Ian

 

[Windsurfer]

Thank you very much Ian, please read my other posted message I believe it will explain things better.
Thanks again,
Emilio