Problem with command ".selected()"

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

Guest

Hi, everybody

my form "Graphikgalerie" bases on "SELECT GraphicDateienAdd.* FROM
GraphicDateienAdd ORDER BY [Endung], [DateiNameOnly];" as its source. One of
its fields is named "DateiNameRef" showing what I want (a path to a .jpg
file). On that form I have a listbox named "DateiNameRefLISTE" with actually
the same source as the form "SELECT [IDadd], [DateiNameRef], [Endung],
[DateiNameOnly] FROM GraphicDateienAdd ORDER BY [Endung], [DateiNameOnly];".
When I go through the records in "DateiNameRef", I want correspondingly have
the relevant entries in the listbox selected. I use the form current event
with the following command:

DateiNameRefLISTE.Selected(CurrentRecord) = True

After opening the form this works once. Trying again I get an fundamental
Error "MSACCESS recieved a fatal error" that ends the application
immediately. I use Access 2000.

Anyone had this problem too? Maybe even knowing a solution?

Ulrich 1947
 
Hello Ulrich.

Ulrich1947 said:
my form "Graphikgalerie" bases on "SELECT GraphicDateienAdd.*
FROM GraphicDateienAdd ORDER BY [Endung], [DateiNameOnly];"
as its source. One of its fields is named "DateiNameRef" showing what
I want (a path to a .jpg file). On that form I have a listbox named
"DateiNameRefLISTE" with actually the same source as the form
"SELECT [IDadd], [DateiNameRef], [Endung], [DateiNameOnly]
FROM GraphicDateienAdd ORDER BY [Endung], [DateiNameOnly];".
When I go through the records in "DateiNameRef", I want
correspondingly have the relevant entries in the listbox selected. I use
the form current event with the following command:

DateiNameRefLISTE.Selected(CurrentRecord) = True

After opening the form this works once. Trying again I get an
fundamental Error "MSACCESS recieved a fatal error" that ends the
application immediately. I use Access 2000.
Click to expand...


How about DateiNameRefLISTE = Me.IDadd ?
 
Back
Top