Question abt POP form to current record details...

good day all,

I have a frmchecking acct that has ID, DATE, Description, Debit, CRedit,
and the pop up form has Acct Type, Reference, transaction notes.

I created a button to open the form to the current record based on ID, and
for a test I put the field ID visible on the pop up form (frmdetails), but
when the form opens from the current record, the ID Still shows (autonumber)
and doesn't "go to" the current record details?

Here is my code:

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmcheckingAdd/Edit"

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

Exit_Command28_Click:
Exit Sub

Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click

End Sub
Any suggestions?

Thanks,

Brook

As long as your ID is numeric that should work fine as long
as the form calling it is on a record itself. Your pop-up
form isn't set to be DataEntry by chance, is it? The
(Autonumber) display usually indicates that it is a new
record waiting to be filled in.

--
Gary Miller
Sisters, OR



"Brook" wrote in message
...
good day all,

I have a frmchecking acct that has ID, DATE, Description,
Debit, CRedit,
and the pop up form has Acct Type, Reference, transaction
notes.

I created a button to open the form to the current record
based on ID, and
for a test I put the field ID visible on the pop up form
(frmdetails), but
when the form opens from the current record, the ID Still
shows (autonumber)
and doesn't "go to" the current record details?

Here is my code:

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmcheckingAdd/Edit"

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

Exit_Command28_Click:
Exit Sub

Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click

End Sub
Any suggestions?

Thanks,

Brook

Hey Brook,

In your Do.Cmd statement try adding:

DoCmd.OpenForm stDocName, , , stLinkCriteria,acFormEdit

and see what happens.

HTH,
Shane

Brook wrote:
good day all,

I have a frmchecking acct that has ID, DATE, Description, Debit, CRedit,
and the pop up form has Acct Type, Reference, transaction notes.

I created a button to open the form to the current record based on ID, and
for a test I put the field ID visible on the pop up form (frmdetails), but
when the form opens from the current record, the ID Still shows (autonumber)
and doesn't "go to" the current record details?

Here is my code:

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmcheckingAdd/Edit"

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

Exit_Command28_Click:
Exit Sub

Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click

End Sub
Any suggestions?

Thanks,

Brook

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200512/1