Going from one Form to another based on field

[akrylik]

I have two forms, Employee Data Input(has employee information on it) Form and a Resource Allocation Form(employee's current project) that I am using to track individuals and their projects. I am trying to create a button to go from the Resource Allocation Form to the Employee Data Input Form based on the Last Name in the Resource Allocation Form. Would docmd.OpenForm be the best way to go? If so, how would i code the parameters to apply that filter?

[pbaldy]

See if this helps:

BaldyWeb wherecondition

[akrylik]

its asking me to enter parameter value. Im trying to get the automated so it doesnt pop up but goes to the correct record.

[akrylik]

This is the code im using :

DoCmd.OpenForm "EmployeeDataInputForm", , , "Last_Name = '" & Me.Last_Name & "'"

[pbaldy]

If you're getting a parameter prompt, one of those is spelled wrong or the field isn't in the second form's source. Is there a space in the field name rather than the underscore?

[akrylik]

Yes there is a space in the name of the button. Should it be me.[last name]?

[akrylik]

When I run it with the following code i get the following error message:

DoCmd.OpenForm "EmployeeDataInputForm", , , "Last Name = '" & Me.[Last Name] & "'"

run-time error '3075':
Syntax error (missing operator) in query expression 'Last Name = 'Adams".

where Adams is the last name in Form 1 and i want to view info on Adams in Form 2

[pbaldy]

You need the field name brackted too:

DoCmd.OpenForm "EmployeeDataInputForm", , , "[Last Name] = '" & Me.[Last Name] & "'"

See why we recommend against spaces?

[akrylik]

IT WORKS! Thanks man.

[pbaldy]

Happy to help!

[akrylik]

Another question, Say i have a submit button and i want to add the same person's name to a new record. I want to hit submit, go to a new form and auto fill the LastName field with the same last name on the previous record. Should i create a temp. variable that holds the value of the last name field and then use that variable to fill the field in the new record?

[akrylik]

Nevermind, i figured it out. Thanks