glitch: opening form to specific record using its ID

[LightByrd]

Hello all!
I have a form which accepts a partspec of a last name and then displays in a
subform all records that match.
I then allow the user to click on the ID of the desired record and opens the
main form to that record.
Here is the code:

' IncidentID is key field of main table
'Me,txtIncidentID is value of textbox in subform
strWhere = "[IncidentId]=" & Me.txtIncidentID
DoCmd.Close
DoCmd.OpenForm "frmcallout", , , strWhere

Works great...except:
When the main form is displayed, if any attempt is made to access another
record (e.g. page down or using the navigation buttons), it opens a new
record.
I would like the displayed record to remain editable (which it is now) but
to return to the Master Menu is any attempt is made to display another
record.

Any ideas?

 

[DrGUI]

In the main form's property sheet, go to the DATA tab. Set the "Allow
Addition" property to No

 

[LightByrd]

In the main form's property sheet, go to the DATA tab. Set the "Allow
Addition" property to No

Would that not preclude additions when the form is used for that purpose
instead of just finding a specific record?

--
Regards,
Richard Harison

Hello all!
I have a form which accepts a partspec of a last name and then displays
in a
subform all records that match.
I then allow the user to click on the ID of the desired record and opens
the
main form to that record.
Here is the code:

' IncidentID is key field of main table
'Me,txtIncidentID is value of textbox in subform
strWhere = "[IncidentId]=" & Me.txtIncidentID
DoCmd.Close
DoCmd.OpenForm "frmcallout", , , strWhere

Works great...except:
When the main form is displayed, if any attempt is made to access another
record (e.g. page down or using the navigation buttons), it opens a new
record.
I would like the displayed record to remain editable (which it is now)
but
to return to the Master Menu is any attempt is made to display another
record.

Any ideas?

--
Regards,
Richard Harison


.