Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old June 27th, 2008, 08:22 PM
ghetto_banjo
Guest
 
Posts: n/a
Default 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
  #2  
Old June 27th, 2008, 08:22 PM
ghetto_banjo
Guest
 
Posts: n/a
Default 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.
  #3  
Old June 27th, 2008, 08:22 PM
ghetto_banjo
Guest
 
Posts: n/a
Default 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! :-)
 

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles