Using Select Queries in Forms

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I'm trying to use a select query to do the following, but it doesnt work - I
will explain why after.

Ive got a database full of names, and want to have a certain form bring up a
listing of names dependant on what the user enters in. For example, if the
user enters in "top", I want it to display any listing with the field
"order" set as "1" or "2" or "3". However, I want this form to be edittable.
I tried using a select query to bring up the listings, which worked, but I
cant edit any of the values.

Is there a way to make it so I can, or a different approach?
 
Generally, select queries aren't editable if they contain more than one
table without containing the primary key of the table you want to edit. Add
they key and you may find your query becomes editable. I'm still not sure
what you want to do, but you can always edit unbound data, then write it
back to the database tables. If the unbound data needs to persist between
sessions, use a temporary table to store it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top