E
Ernst Guckel
Hello,
I have a contacts form that has client and contact info on it. There is
one combo box that I can select from my available clients. The after update
event triggers this code:
Set rs = Me.Recordset.Clone
rs.FindFirst "[tblClients]![ClientID] = " & Str(Nz(Me![cboCompanyName],
0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
The problem is that the second combo for the contact within the current
client lists the contacts for the client but how do I adapt the code to
update infor for the individual contacts?
record source for form is :
SELECT tblClients.*, tblClientContacts.* FROM tblClients LEFT JOIN
tblClientContacts ON tblClients.ClientID=tblClientContacts.ClientID;
each field is bound to its respective field within the tables...
Ernst.
I have a contacts form that has client and contact info on it. There is
one combo box that I can select from my available clients. The after update
event triggers this code:
Set rs = Me.Recordset.Clone
rs.FindFirst "[tblClients]![ClientID] = " & Str(Nz(Me![cboCompanyName],
0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
The problem is that the second combo for the contact within the current
client lists the contacts for the client but how do I adapt the code to
update infor for the individual contacts?
record source for form is :
SELECT tblClients.*, tblClientContacts.* FROM tblClients LEFT JOIN
tblClientContacts ON tblClients.ClientID=tblClientContacts.ClientID;
each field is bound to its respective field within the tables...
Ernst.