Search results

also i would take of auto resize since that is what is making it shrink

It can be done however it would take mostly VB coding and not just point and click. I dont know of an option to do that but you could certainly creat a list box and populate it use a few sql queries and some vb.

have you tied using a * in place of all? and try to let access right the sql code for you and see what it does.

This happens when you go to the next record only in one form?

Have you been working with this form alot. I believe that if you have a event named twice in your code you will get this error message. Its been awhile and i cant test it right now but thats to the best of my knowledge anyway sorry i cant be more help

Hello, Yah that will work to use the box but im curious how can you let the user look up a last name for instance by type smith on the keyboard in a list box. Instead of only being able to type 's' then scroll down to smith. Thanks again

Either have the record Id automatically created or ask for it before you enter the main form. I used to have the problem when I created access programs that I would use the same form to lookup,create, and edit I have since adopted to policy of creating seperate forms to do these tasks that look...

I would suggest that you not use access tool bar to navigate records because I don't believe that it is possible to stop showing it after the last record however you might try looking up suppressing error messages.

I am creating a list box for users to be able to lookup information in one list box that is unique and display all entries in the list box next to it. That works great exept there are more uniques then I first thought and the users are only able to select the first key to shorten the search. I...