N
Neil Cash
I have a main form with a subform on it. Within the subform I have a command
button that opens another form depending on what the value of the combo box
next to it contains. What I would like for the opened form to do, is to go
to a record that matches a field in the main form [Project Number]. And if
one doesn't exist, I'd like it to create a new record with the Project Number
filled in from the main form. I've tried this goto record command thus far
to go to the record containing the Project Number:
Me.RecordsetClone.FindFirst "[Project Number] = " & Me![Forms]![Plan
Status]![ProjectNumber]
Me.Bookmark = Me.RecordsetClone.Bookmark
But it's saying it can't find the field "Forms" reffered to in my
expression. Any ideas on this and the new record option? Or should I give
up hope and try another approach? Thanks in advance
button that opens another form depending on what the value of the combo box
next to it contains. What I would like for the opened form to do, is to go
to a record that matches a field in the main form [Project Number]. And if
one doesn't exist, I'd like it to create a new record with the Project Number
filled in from the main form. I've tried this goto record command thus far
to go to the record containing the Project Number:
Me.RecordsetClone.FindFirst "[Project Number] = " & Me![Forms]![Plan
Status]![ProjectNumber]
Me.Bookmark = Me.RecordsetClone.Bookmark
But it's saying it can't find the field "Forms" reffered to in my
expression. Any ideas on this and the new record option? Or should I give
up hope and try another approach? Thanks in advance