Re: Bounded Columns vs Recordset

From: Ken Snell (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 07/03/04 

Date: Sat, 3 Jul 2004 17:17:55 -0400

Why? This involves code to get and then create the Row Source List for the
combo box. Recordset will be based on a query, so why not just use the query
as the Row Source? What is it you want to do that makes you think you should
use a recordset? 

-- 
        Ken Snell
<MS ACCESS MVP>
"vb" <vb@discussions.microsoft.com> wrote in message
news:05AA40FA-B7FB-485D-B70C-863BBA30ADAB@microsoft.com...
> Thanks for the response,
> I am  thinking of getting data as a recordset and assign the values to
Combobox instead of having a SQL statement in the RowSource Property.
>
> Any suggestions/more thoughts
>
> vb
>
> "Ken Snell" wrote:
>
> > Using SQL statement as the row source for a combo box is typical. You
might
> > get slightly faster performance if you store the SQL as a query and then
use
> > the query name as the row source, but I doubt you'd notice a difference
for
> > most operations.
> > -- 
> >
> >         Ken Snell
> > <MS ACCESS MVP>
> >
> > "vb" <vb@discussions.microsoft.com> wrote in message
> > news:2E3CF00D-03B9-47D8-9E80-9216F718B55B@microsoft.com...
> > > Hi,
> > > I am new to Access. I want to use directly the SQL statement in the
Row
> > source in the ComboBoxes. There will be about 5 or 6 comboxes in a
screen. I
> > am just thinking is this a good programming method or do I have to go
for
> > the recordsource and populate the values for the Combo boxes? If I use
> > direct SQL statement in the Row source will there be any performance
issues?
> > All the combo boxes have the same values being listed.
> > >
> > > Any guidance is greatly appreciated.
> > >
> > > thanks
> > > vb
> >
> >
> >

Relevant Pages

  • Re: Viewing the contents of two tables using ASP and MS Access
    ... Number of fields in a recordset 255 ... Number of characters in a cell in the query design grid 1,024 ... Number of characters in an SQL statement approximately 64,000 ...
    (microsoft.public.inetserver.asp.db)
  • Re: Opening a query in MS Access with parameters using VB.net
    ... datasource to a SQL statement. ... using the stored query as the datasource. ... Dim rs As Recordset ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Form Advice Relating to Queries
    ... Create a new query that uses the tblContacts table. ... Row Source Property Entered By Query Wizard ... I have tried the SQL Statement in the combo box Row Source Property as ...
    (microsoft.public.access.forms)
  • RE: Combo Box Problem
    ... There are quite a few subroutines in the VBA window (I did ... the row source of my second combo. ... >If the row source for the second combo is a SQL statement ... >> query to ...
    (microsoft.public.access.gettingstarted)
  • RE: record set trouble
    ... 'Set the row source of the info form to the query ... I believe that you must open the form THEN set its recordset property. ...
    (microsoft.public.access.formscoding)
Loading