table/query

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

Guest

I put in the table under: Display Control - List Box
Row Source Type - Value List
Row Source - " X....;"Y.....;";
"Z....."
When I go to the query I don't see these: X...., Y....., Z.... in the drop
down menu.
(Under the Data Type is Text, of course.)
I'd appreciate reply.
Alex.
 
Alex,

There should normally be no need for this type of functionality in a
table or query, as these are not normally used for data
entry/edit/manipulation. In any case, as far as I know, you can't have
a Listbox in a table or query datasheet. This is applicable to controls
on a form. If you set the Row Source Type and Row Source properties of
a Listbox (or Combobox for that matter) on a form, to the type of
sntries you gave in your example, I think you would get the results you
desire.
 
Steve,
Thank you for reply but my knowledge of Access isn't good enough to
understand it.
Most of the fields in my Table are: Data Type is Text, in Row Source -
different values. The Query is exactly parallel to the Table, and in the
Query fields I put different values (which is precoded in the Table in Row
Source). But for some fields in the Query i can't get even a 'v' - an arrow
sign(drop down menu) to put values which are present in Row Source in the
Table. And I don't know why. If you think it could help I can Zip my database
to you.
Alex.
 
Alex,

You appear to be making extensive use of Lookup fields in your table
design. And you appear to be trying to use a query datasheet for data
entry. Both of these things will cause unnecessary difficulty for you.
You need to work out what data you want in your tables, design them by
defining the data type of the actual data that will be in each field,
forget all about Row Sources, and think of the table as "hands off, data
storage area". And for entry/editing/viewing of the data, you need to
build a form. And then, if you want to use a combobox or a listbox on
the form to facilitate data management, that's good... but that's
another topic!

It might take a bit of work to get this under your belt, but it will be
worth it.
 
Back
Top