DLookup "engine cannot find a record" when new record created.

[gcoaster]

Hello!

I am having problem with DLookup Function

DLookup looks on form, and finds the combobox = cboFullName and then compares it to the column clientID in tblCLIENTS table. if they match, email is put in text box on form named clientEmail and the control source for that field is linked to a table tblCALLS and clientEmail column.

Not sure if DLookup is right for this.. anyways,

here is the Code

Me.clientEmail = DLookup("[email]", "tblCLIENTS", " clientID = cboFullName")

Problem is, when I cycle threw records and come to end and new is created.
VBA wont let me navigate to prev and complains " engine cannot find a record in the table 'tblCLIENTS' with the key matching field(s) 'clientFK'

thank you! you guys have helped me out immensely!

[missinglinq]

I would assume that your combobox, which apparently holds the clients names, is based on your tblClients. If this is correct, and name and email address is, in fact, the same table, why not simply include the the email field in the combobox and reference it from there?

If the first field of the combobox holds the name and the second field holds the email address, this code should do the job:

Private Sub cboFullName_AfterUpdate()
  Me.clientEmail = Me.cboFullName.Column(1)
End Sub

Linq ;0)>

[gcoaster]

Thanks bro!
that worked wonderfully,

Instead of placing code in
Private Sub Form_Current()

Placed here fixed it!

Private Sub cboFullName_AfterUpdate()
Me.clientEmail = Me.cboFullName.Column(2)
End Sub

You are a genius!
and no way is your great great granpa an Ape!

[missinglinq]

Glad we could help!

Linq ;0)>