Access 2003 - a link that opens what's on a drop down menu

[cabonegro]

Hi everyone,

I have a form that has a drop down list which has names of lawyers these name are stored in a table called "Lawyers". I created a link in case a user needs to open the form that has all information about lawyers however when the form opens up it open with the first name in the list and not what it was chosen in the drop down list.



So what I'm trying to do here is when a user clicks on the LINK the lawyers form open with the info about the lawyer chosen in the drop down menu!!

Please let me know if you have any questions!

Thanks in advance

[pbaldy]

One way:

BaldyWeb wherecondition

[cabonegro]

Thanks for the reply, I'm new to programing so please be patient

I tried applying the code you refered on your reply but it didn't work!
Here is what I have:
Form1 has a drop down list named "Lawyer name"
Form2 that I want to open straight from a link in Form1 has a field called "First&LastName"

I created a field named "open" and I added the following code:

DoCmd.OpenForm "Form2", , , "Lawyer name = '" & Me.open & "'"

Do you have any idea on what I'm doing wrong?

Thanks

[pbaldy]

Due to the inadvisable space in your name, it needs to be bracketed:

DoCmd.OpenForm "Form2", , , "[Lawyer name] = '" & Me.open & "'"

[cabonegro]

I tried it again and still no luck!

- the link I created to open a form was by adding a command button named OPEN and specifying that it should open form2 than I added the code to it.

Is this the right way of doing it?

[pbaldy]

Probably; what's the complete code for the button now? Can you post the db?