Frm Views

AN60

Registered User.
Local time
Today, 22:47
Joined
Oct 25, 2003
Messages
283
I use a button on a main frm to open a second frm which I use occasionally to edit a qry. The I wish to view the frm (Editing one) in Datasheet view. My problem is that I can't get the frm to open as datasheet. I've tried setting the properties to datasheet only + only allow only the datesheet view. Even with this the frm opens as a normal frm. Datasheet allows more data to be viewed & suits my needs better. I can right click & convert the view to datasheet if necessary but obviously do not want to do that. Any ideas on how to open it up as a datasheet?
 
frmViews

If you set the form open method in Visual Basic to the following, it should work;

Code:
DoCmd.OpenForm "Your Form",acformDS


Cheers & Beers
 

Users who are viewing this thread

Back
Top Bottom