acEdit

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

Guest

press commandbutton
openquery, acnorm,acEdit
MSG bos - do you want to abort?
If vbYes Then
GoTo Exit_COMMBUTTON_proc

how come I am left looking at a query ouput display but I can no longer edit
a field?
I tried
If vbYes Then
openquery, acnorm,acEdit again, but that didn't make a
difference
 
The default for a msgbox is the ok button only (you need to test vbOK), do
you want to allow yes?
If so, you need to say:
msgbox "message",vbyesno,"title"
Then you can test vbYes or vbNo

-Dorian
 
how come I am left looking at a query ouput display but I can no longer
edit
Dorian, you totally missed the question. I am having no problem with MSGBOX.
The problem is with openquery. Why am I not able to edit fields displayed
in the query?
 
Dorian, you totally missed the question. I am having no problem with MSGBOX.
The problem is with openquery. Why am I not able to edit fields displayed
in the query?
Click to expand...

Just a couple of comments:

- Not all queries ARE editable. See "Updateable" in the online help -
some queries can be updated, some cannot.

- Most developers would recommend NEVER using table or query
datasheets for editing in any case. Use a Form (based on an updateable
query of course).

John W. Vinson[MVP]
 
Back
Top