Storing a record

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I want users to be able to click a command button on a form and that takes
them to another form (I got that part written) where they can add a record to
the second form. That record is then stored in the underlying table of the
first form. Thanks so much!!!
 
Sorry, Golfinray. Is there a question in there?
What part are you having trouble with?
 
Here is my problem. My query is not editable because the tables the query
runs on are ODBC linked tables to an sql server. I even tried copying and
pasting them as local tables but it still won't allow my query to be
editable. (there is no arrow and asterisk at the bottom, only a forward arrow
and back arrow) Since my query is not editable, my form isn't either. My
users need to be able to add new records to my form and store them in a
table. What is the best alternative? Can I somehow make the query editable
and then the form will be editable also? If not, my question concerned making
a separate form just for storage of new records. If that is possible, how
would I go about coding that? I tried everythin I know to do, including
runcommand accmdrecordsgotonew and setting up me.recorsetclone to try and get
a save table. Thanks so much for your help!! Any suggestions greatly
appreciated!
 
The query being based on a linked ODBC table is not why it is not editable.
The problem is the query is uneditable because of how it is constructed.
Union, crosstab, Totals, and some queries based on multiple table create
uneditable recordsets.

Let's start with the query. Can you post back with the query's SQL so we
can see what the problem may be, please?
 
Back
Top