I want to thank you all for your help. I was making things much more difficult than they had to be. pono1 thank you for your example it helped me understand more about what I was doing wrong. For instance instead of just setting the list box source to the actual table, I defined specific...
right I'm in need of a bit of help. I am pretty weak with my vba skills and I'm hoping someone can spell out how to accomplish the task I wish to accomplish.
Here's the scenario:
I have an Access 2002 db
table = tblcustomers
CustomerNO field = primary key
Lname = field I wish to populate my...
I cannot delete the other post
Chris,
I didn't realize it posted twice. It must have posted once when I went to preview it, and then when I hit submit.
Any I went into the other post and it will not let me delete it because I don't have admin rights. Sorry.
Thank you
Thank you for the reply. I see where you are going with most of this code, but could you explain to me what this part is doing--sorry i'm a little new at the coding !!
"UserName = " & Chr$(34) & CurrentUser() & Chr$(34)), 0)
Presently I have a form that is functioning from a specific table within my database. As the user enters individual sales information information into the form I need to be able to pull user data from another table. Essentially what I am trying to acoomplish is to be able to identify a user...