Box to look up name

[BartK]

Hello everyone,
I have absolutely no clue how VBA or Modules work.

So here goes, I've got a report called "Incident Summary" and on my report I have a button called "Employee Injured" that I wish to pull up the entire record of the name input into my box and have it put into my report called "Incident report".

I will be sure to post my db so you can review it and tell me what exactly I need to do. I have some code that I think is pointing me in the right direction, more than likely not.

Thanks in advance to everyone.

 

[jdraw]

Here is a link related to Access and vba.
http://www.accessmvp.com/strive4peace/VBA.htm


Here is a link on database design.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

 

[plog]

Allow me to expand on jdraws post by being both harsher and more detailed. Your post is equivalent to asking how to paint the upstairs bathroom of a house who's basement walls are are crooked and made of paper mache.

You need to spend some time properly structuring your tables before you move any further. Mostly I see poorly chosen field types--looks like everything is a short text field. If a field is to hold numbers--make that field a numeric data type, if it is to hold dates, make it a date data type. Also, if you need to store both date and a time of an event, make that field a date/time datatype and store that data in one field, not spread over two (one for date, one for time) .

You also need to use primary and foreign keys, better name your fields (Date and Time are reserved words and making coding and writing queries more difficult). All of that is covered in the 2nd link jdraw posted. I'd read that one first, and then the VBA one.