• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 521
  • Last Modified:

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

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
SteveL13
Asked:
SteveL13
  • 2
1 Solution
 
mbizupCommented:
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
 
SteveL13Author Commented:
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
 
mbizupCommented:
The alternative is data sheet view, which CAN be set at runtime...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now