Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

www.webdp.net, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format

Links

XODOX
Impressum

#1: Open Form based on List Selection

Posted on 2008-04-20 23:34:28 by ghetto_banjo

Ok, i thought i had this one figured out, apparently not.

Here is my code on my button click event:

stDocName = "frmInvoice"
stLinkCriteria = "[InvoiceNum]=" & Me![List13]
DoCmd.OpenForm stDocName, , , stLinkCriteria


List13 is a single column list box of invoice numbers. When I choose
an invoice in teh list, and click my edit button, the form opens up
with the first record of the Invoice Table (frmInvoice bounded to this
table).


What am i doing wrong? Do you need more information to help me?

Thanks

Report this message

#2: Re: Open Form based on List Selection

Posted on 2008-04-20 23:42:42 by ghetto_banjo

And when i say it opens to the first record on the table, it is NOT
the invoice # i selected in the list box.

Report this message

#3: Re: Open Form based on List Selection

Posted on 2008-04-21 00:30:59 by ghetto_banjo

Nevermind, it was a 1 D 10 T error.

Somehow frmInvoice had DataEntry = Yes, so it was ONLY allowing new
records on opening. its always something stupid like that with me!!!


2 hours of my life flushed away! :-)

Report this message