Basing a form on a RecordSet Instead of a Table/Query - MC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to base a form on a recordset instead of a table or query, and
if so, could someone point me to a good example. The VBA Help on my PC is
not very good (not all the pages appear), so I'm looking more for an
web/external source.

Thanks In Advance

Mark
 
Your question is unclear. All recordsets are either queries or tables. The
can be external by linking to a data source such as an Excel spreadsheet, a
FoxPro database, text files, etc. When you say web, what do you mean? What
form is the data in?
 
MChrist said:
Is it possible to base a form on a recordset instead of a table or query, and
if so, could someone point me to a good example. The VBA Help on my PC is
not very good (not all the pages appear), so I'm looking more for an
web/external source.
Click to expand...


I agree with Klatuu, most any time you you open a recordset,
you could use that as the form's RecordSource.

Since A2K, forms have had the Recordset property that you
can set. If you do have one of those rare situations where
this really is needed, see if you can find it in your Help
system.
 
Marshall,

If finally found where you can base a form on a recordset without a table or
query in the Help, now however, when I run the form, I see the proper amount
of records, but there are no fields to display in design view.

Any suggestions?

Mark
 
You'll have to work without the field list in the form's
design view. The field list comes from the form's
RecordSource table/query and without that you will not have
a field list to work with.

You are taking a very unusual approach and you have not
provided any background info that might allow someone to
come up with an alternative design or even suggestions on
how to work with whatever situation you're trying to deal
with. At this point we would just guessing about what might
help you out here.
 
Back
Top