G
Guest
Hi - I posted tis in microsoft.public.access.formscoding a week back and Guy
who replied (thanks Guy), but did not spot any obvious errors, suggested
posting here. In the meantime I am opening the detail for as acDialogue which
gets round the problem but isn't as usefull to the user .
Im having some strange behaviour with the OpenForm method now my mdb is
upsized to adp.
I have a continuous form to display a list of records, the user selects a
record and clicks an edit button. The code behinf the edit button is below;
Private Sub cmdEdit_Click()
Dim strWhereCondition As String
strWhereCondition = " ID = " + CStr(Me.sfrmMainRespondentList.Form.ID)
DoCmd.OpenForm "frmRespondent", acNormal, , strWhereCondition,
acFormEdit, acWindowNormal
Call cmdClearSearch_Click
End Sub
All work fine. The second form is opened and displays the record to edit.
If without closing the second form I go back to the list form and choose
another record and click edit then the second form (already open) displays
that record.
Now I upsize to adp.
Choosing a record from tthe list form and clicking edit brings up the second
form with the correct record. Going back to the list choosing a different
record and clicking edit brings up the second form but with no data - it
looks like it has created an empty new record.
The form (second form) record source is set to a query (now a view) in esign
view.
The RecordSource property reads 'qryRespondent' (without the quotes.
Any ideas?
who replied (thanks Guy), but did not spot any obvious errors, suggested
posting here. In the meantime I am opening the detail for as acDialogue which
gets round the problem but isn't as usefull to the user .
Im having some strange behaviour with the OpenForm method now my mdb is
upsized to adp.
I have a continuous form to display a list of records, the user selects a
record and clicks an edit button. The code behinf the edit button is below;
Private Sub cmdEdit_Click()
Dim strWhereCondition As String
strWhereCondition = " ID = " + CStr(Me.sfrmMainRespondentList.Form.ID)
DoCmd.OpenForm "frmRespondent", acNormal, , strWhereCondition,
acFormEdit, acWindowNormal
Call cmdClearSearch_Click
End Sub
All work fine. The second form is opened and displays the record to edit.
If without closing the second form I go back to the list form and choose
another record and click edit then the second form (already open) displays
that record.
Now I upsize to adp.
Choosing a record from tthe list form and clicking edit brings up the second
form with the correct record. Going back to the list choosing a different
record and clicking edit brings up the second form but with no data - it
looks like it has created an empty new record.
The form (second form) record source is set to a query (now a view) in esign
view.
The RecordSource property reads 'qryRespondent' (without the quotes.
Any ideas?