Adding data to query

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

Guest

I've got a query built on several tables and 2 other queries. Works fine but
I need to have a field in the final query that I can use to mark specific
records in the query and then sort on that column. I added a field to one of
the tables and made it a value lookup. Bringing that into the query results
in the cell showing the options but emitting a chime when I try to select one
of the options. Other things I've tried end up putting the same value in the
same field of all records. Is there a property I need to set. Guidance will
be appreciated. H.
 
It sounds like you have created a recordset that can't be edited. For a
query to allow edits, the tables are generally joined on primary-foreign key
fields. The more tables/queries you add to a query, the less likely it is to
be editable.
 
Probably so. I'm just learning about different types of queries. So I built
a form off to the same query and looked for ways to mark certain records
there too. I tried a text box that was connected to an underlying table.
Result was that if I marked one record, all records got marked.

So in the query, I like that the records are not editable. But is there any
way to look at that data and be able to mark single records without starting
over? Again, my goal is to mark certain records and then isolate those
records for further sorting and printing. Thanks. H
 
I rarely have a form with a record source involving more than a couple
tables. You can add in other tables using list boxes, combo boxes, and
subforms.
 
Back
Top