command button

[berni3883]

Hi,

How would I go about having a command button on a form to open another form to a specific record.
I have tried and tried but cannot do so. The 2nd form open to the first record everytime.

[pbaldy]

Does this help?

BaldyWeb wherecondition

[berni3883]

thank you for your reply. Where would I put that though? What I did was make a combo box on my form to list all the students on the second form. And then I have a command button that is supposed to take me to the selected student on my second form. But the command button wont do that.

[pbaldy]

That VBA code would go in the button's Click event.

[berni3883]

I am getting a syntax error? I have no idea what I am doing wrong.

[pbaldy]

Did you use the format appropriate to the data type of the field?

[berni3883]

yes the field is text so i used the text format. I copied and pasted what you had and replaced the form name, field name, and control name

[pbaldy]

What exactly is your code?

[berni3883]

DoCmd.OpenForm "Student Form", , , "Student Name = '" & Me.Student Name & "'"

[pbaldy]

The inadvisable spaces will require you to bracket names. Try:

DoCmd.OpenForm "Student Form", , , "[Student Name] = '" & Me.[Student Name] & "'"

[berni3883]

The syntax error is still popping up

[pbaldy]

Can you post the db here?

[berni3883]

It is too large for me to upload. is there another way I can attach it?

[pbaldy]

If you compact/repair and then zip, most db's will be small enough. If not, email it to

pbaldy
gmail
com

[berni3883]

So this might be the problem... i have 2 forms. My student form has all the students info listed in it. I combined the students last name and first name into one field using this:
=[Last name] & ", " & [First name]

so how would this fit into your VBA code?