[bblakel1]

Hello,

I am new here and this is my first post so let me know if I am doing anything incorrectly. I have an Access DB, and I am trying to create a button on one Form that will pull up another Form and display the associated FK. Here is the VB code I have so far, but I know it is missing something. It has been a long time since I have done any VB and I was not great at it then. Any help would be much appreciated.

Private Sub Command21_Click()
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "the form I want to retrieve"

stLinkCriteria = "employeeID" = " & Me![employeeID]"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.GoToRecord , , acGoTo, (this is were I get lost)

End Sub

[OBP]

bbalke, welcome to the Forum and the wonderful world of Access.

Your VBA is fine up to this point

DoCmd.GoToRecord , , acGoTo, (this is were I get lost)

What is it that you want the VBA code to do at this point?
The newly opened form should already be displaying the Employee Record(s) that match the EmployeeID.

What version of Access sre you using, if it 2007 it has problems with that particular piece of code.

Have you considered have the second form as a Subform of the First form?
Or having a Tabbed Mainform that shows both forms on it?

[bblakel1]

The database has two tables that are linked. One with employee info and one with their PC info. I want to be able to click on the button from the employee info Form and it pull up their PC.

Currently it just pull up the PC Form and it's blank. Could it be the way I have them joined in Access? I am using Access 2003. Thank you very much for the help.

[OBP]

Can you show me a Screenshot of your Relationships?

I would go for a Tabbed mainform, the Mainform, based on the Employee table with the EmployeeID and a Find Combo with tab one with Employee Details and tab two with the PC details. You can then just Link the form's by Master/Child Link using the EmployeeID.

If you need advice on how to do the tabbed form feel free to ask

[bblakel1]

Here is the .bmp of my relationships.

[OBP]

Sorry, it doesn't appear to have attached.

[bblakel1]

Try #2, I guess Google Chrome still has some clitches. Sorry.

[bblakel1]

Sorry, user error. The file was too large as a .bmp.

[OBP]

Still not there.
Are you using the "Go Advanced" and "Manage Attachment" Buttons?

[OBP]

They look good to me.
Can you take a copy of the database, delete all the records from the copy, Compact & Repair it, zip it and post it on here?

[bblakel1]

Thank you very much for looking at it. There is not a password on it. The button I am trying to get to work in on the Tech Form (command 21). Thanks again.

[OBP]

Like this.
Let me know if you want to try a Tabbed Mainform.

[bblakel1]

You are my hero. Thanks so much for the help! It works great now.