Open Form based on List Selection

Open Form based on List Selection

am 20.04.2008 23:34:28 von 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

Re: Open Form based on List Selection

am 20.04.2008 23:42:42 von 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.

Re: Open Form based on List Selection

am 21.04.2008 00:30:59 von 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! :-)