datasheet

[wdu94]

Hello,

I have a datasheet form when I directly open it that show up datasheet form but when I click button to link to this form that show up single form. I need this form always show datasheet. In the design view, this form is a datasheet.

Any suggetstion?

Thank you very much.
Jeannia

 

[tempclerk]

In form properties, set the Default View to Datasheet, and maybe Views Allowed, too.

 

[wdu94]

Yes, I already set up Default view to datasheet, but always show single form when I click button link to this form.

Any ideas?

Thanks again
Jeannia

 

[dvannoy]

I had the same problem. The only way I could open a form from a button etc in DataSheet View was to create a Macro and set the form to datasheet view. I know this sounds crazy but it's the only way it will work. On the command button just run the macro and it will work.. DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tempclerk]

Did you look at the code behind the button? Maybe the view is specified there.

 

[wdu94]

I don't have any special code there, I just have one code:
Docmd.OPenForm "frmtblPsw"

By the way, I don't know how to use macro?? I am really newer about access project.

Thanks
Jeannia

 

[tempclerk]

Try using Docmd.OPenForm "frmtblPsw", acFormDS
or Docmd.OPenForm "frmtblPsw", acNormal

 

[dvannoy]

OK...goto the macro section...click on new. The first line would be openForm...then at the bottom you will see form name etc...select the form you want to open..in the view section select datasheet view.

name the macro what ever you wish..

The instead of DoCmd.OpenForm "frmtblpsw" type

docmd.runmacro "macroname"

That should work


DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[wdu94]

Thanks. You both are right.