( Newbie )

[Steinarr G.]

Two silli questions. )

nr. if i reply to message.. then i can only reply tho the group..
i select that message and press reply to group .. if i only press reply then
it goes
to the one that sent it. .. not to that message.

what am i doing wrong here..

using .. exspress latest.

nr2

I have a form that does like this..


Private Sub PreviewInvoice_Click()
On Error GoTo Err_PreviewInvoice_Click

'## begin

Dim strSQL As String

strSQL = _
"INSERT INTO facturer (name, address) " & _
"VALUES('" & Me!name & "','" & Me!Address & "')"

CurrentDb.Execute strSQL, dbFailOnError

DoCmd.OpenReport "Invoice", acViewPreview
Me.Visible = False
MsgBox "The Report has been saved. "

Exit_PreviewInvoice_Click:
Exit Sub

Err_PreviewInvoice_Click:
MsgBox Err.Description
Resume Exit_PreviewInvoice_Click
End Sub

'## end

then this record gets it´s ID and then the report opens.

The Report gets info from Existing form and 2 tables.but it´s the first
record from the tables.. like for company info and so on.

Now i nead to bring out the ID on that record from the table
as this was the last one in, it´s the higest ID .. like using DESC in sql.

but .. i´m trying Dlookup in the form field..
I´m not finding this out so fast..

Any tipps.. ??

thankes..

Steinarr G.