Solved

How open form using query as its record source and in continuous mode?

Posted on 2013-11-14
3
455 Views
Last Modified: 2013-11-14
I have a form that normally opens as a single form and uses a table as its record source.  But I want to also be able to open the form from a command button on a menu form in continuous mode and use a query as it's record source.

How do I code this?
0
Comment
Question by:SteveL13
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39648042
You can't switch a form from single form view to continuous forms at runtime.  That is a design-view only option.

So, create a form similar to your original (you can even copy it) and set your query as its recordsource. Set the default view to continuous forms.

Then just open it like any other form:

Docmd.OpenForm "YourContinuousFormName"
0
 

Author Comment

by:SteveL13
ID: 39648070
Ok.  But that's a shame because if I make a design change in one I have to make the same change in the other one.  Oh well.

Thanks much.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39648100
The alternative is data sheet view, which CAN be set at runtime...
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now