Popup form

[don2241]

I'm trying to do the simplest thing but I cannot get it to work.

I have a click function that when its clicked have a popup form or a new form being displayed where I then will provide data to be stored in table.

After consulting the popup help file in access I am trying this bit of code, that do not work.

Private Sub listPlanner_Click()
Forms!("frmBookingDatePopup").popup
End Sub

I get an error message saying:
Type-declaration character does not match declared data type

Just a bit confused since I've done exactly like in the help file.

Any help appreciated

/M.

 

[DanJR]

I believe you can only use that property in form design view ie, when you are creating a new form using code

check out:
docmd.openform

cheers,
dan

 

[RoyVidar]

There's a little mixup in the syntax, the bang (!) operator doesn't work when using this syntax, but I think DanJR is correct ( also found in the help files), this state can only be altered when the form is in design view, so you could open it in design view and switch, then open in form view, but much easier would be to open the form with the acDialog arguement:

[tt]docmd.openform "myform",,,,,acDialog[/tt]

Roy-Vidar