Open form command

[GooGoocluster]

I am full of questions today...

I have a subform that is linked by the master Fieldname "project" what I want to do is use an entry form to creat new records with the "project" also linked here is the code I have. It works if the "Project" is already created. But I need it to display the ID even if its not created.

Code:

Private Sub AddJob2_Click()
On Error GoTo Err_AddJob2_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "InserterJobs entry"

stLinkCriteria = "[Project]=" & "'" & Me![Project] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_AddJob2_Click:
Exit Sub

Err_AddJob2_Click:
MsgBox Err.Description
Resume Exit_AddJob2_Click

End Sub

 

[GooGoocluster]

When I reread what I posted its unclear, So I will explain better.

The sub-form is displaying the current "project". I have a button on the same form which opens an entry form that displays the current "project" ONLY if that record has associated record with it. My table looks like this with sub-table under it:

[Project][Client]
Apples | Turkey
+ [Job][QTY]
app01 | 3500
Bannanas|Stuffing
Oranges |Pie
+ [Job][QTY]
org01|200
org02|4500

I hope you see what I am geeting at. Anyhow if i were to run my code the project "bannanas" would not show up because it has no sub-data. but the rest would I hope I made things clearer if not I can try again.

 

[ProgramError]

Totally baffled!

Are you trying to open a form for data entry based on the current record showing in the subform, only if the subform record has additional data associated with it?



Program Error
Programmers do it one finger at a time!

 

[TheAceMan1]

How are ya GooGoocluster . . . . .

[blue]Whats wrong with entering a new record on the subform itself?[/blue]

See Ya! . . . . . .

 

[GooGoocluster]

Ok I figured it out. Here is my solution.

I made an entry form with the parent projects information as a main form and then created a subform with subtable then linked them.

The problem I was having was the table I was using for the source did not have all of the records that my main table had. i.e.

Parent table: Project
Sub : Job

My subtable Job had a project feild also to tie them together. But only had data in that feild when there is a job that corrisponds with that project.

So when I was using the entry form with job and my source, when ever there was a Project that was not created in the job table. The entry form would have nothing in the project field. So if I made a new record it would have no parent.