Datasheet View not showing properly

[trident]

I have created a form as a Datasheet. When I incorporated the form to a button, it is not working properly.

Whenever I click the button, the form will open but will show only 1 line of data on a stack format and not in Datasheet view.

can anyone explain this to me.

I tried changing the view on the properties, but it is still the same problem.



Thank you for your assistance.

Trident

[CJ_London]

what code are you using to open the form?

[Missinglinq]

When opening one Form from another Form (regardless of what the Default View is for the second Form) you have to explicitly tell Access to open it in Datasheet View, like this:

DoCmd.OpenForm "YourFormName", acFormDS

Linq ;0)>

[rpeare]

I don't use datasheet view forms but may it also be you are not using 'continuous' rather than 'single' as your form view?

[CJ_London]

in form properties set default view to datasheet

then set all 'allow view properties' to no except the datasheet view which should be yes

[Missinglinq]

Once again, it doesn't matter how the Form Properties are set in the Form itself, in order open a one Form, in Datasheet View, from another Form (which is what the OP is doing, given his statement "Whenever I click the button, the form will open...") you must set the View Parameter of the OpenForm to acFormDS:

DoCmd.OpenForm "YourFormName", acFormDS

Linq ;0)>

[trident]

Thank you guys for the reply.

What I was using was the MACRO event for the button and followed the instructions in there.

The messages are enlightening and the solution/s provided will be test.

I will inform if it works.

Again, Thank you.

Trident.

[Missinglinq]

When posting a question you always need to state that you're using a Macro; very few experienced developers use them or have experience with them.

Once again, you have to explicitly tell the Access Gnomes to open the Form in Datasheet View.

Open your Macro in Design View, go down to just below where you entered the Form Name and under 'Form View' select Datasheet.

If you plan on doing much development, in Access, you really need to start leaning VBA; Macros tend to be very restrictive in what you can do and how you can do it.

Linq ;0)>