Linking Forms to Tables using VB code

[Rendrick]

I am using a form called EnterData to input data into a table and I am having issues getting the Form to link properly. I open EnterData in another form called NewReport. In NewReport I use the following code:

Dim stDocName As String
Dim stLinkCriteria As String
 
stDocName = "EnterData"
Forms!EnterData.RecordSource = "SELECT * FROM Employee10"
DoCmd.OpenForm stDocName, , , stLinkCriteria

I create the table Employee10 with several columns and then call the above code. However when I call the above code, the form is opened but never linked to the right table. Thoughts?

Thanks

[MMcCarthy]

I am using a form called EnterData to input data into a table and I am having issues getting the Form to link properly. I open EnterData in another form called NewReport. In NewReport I use the following code:

Dim stDocName As String
Dim stLinkCriteria As String
 
stDocName = "EnterData"
Forms!EnterData.RecordSource = "SELECT * FROM Employee10"
DoCmd.OpenForm stDocName, , , stLinkCriteria

I create the table Employee10 with several columns and then call the above code. However when I call the above code, the form is opened but never linked to the right table. Thoughts?

Thanks

You can't set the record source before the form is open. Try putting this in the load event of the EnterData form.

Me.RecordSource = "SELECT * FROM Employee10"