Open Form based on List Selection

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
ghetto_banjo [ So, 20 April 2008 23:34 ] [ ID #1946262 ]

Re: Open Form based on List Selection

And when i say it opens to the first record on the table, it is NOT
the invoice # i selected in the list box.
ghetto_banjo [ So, 20 April 2008 23:42 ] [ ID #1946263 ]

Re: Open Form based on List Selection

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! :-)
ghetto_banjo [ Mo, 21 April 2008 00:30 ] [ ID #1946807 ]
Datenbanken » comp.databases.ms-access » Open Form based on List Selection

Vorheriges Thema: Supply Sale Store Distributor Manufacturer Running Shoes Mens Womens
Nächstes Thema: Unbound Form to update multiple tables