L
ldiaz
I have this question:
I have a form where the field is Combo1 and it has a source like this:
SELECT Users.UserID, [LastName] & " , " & [FirstName] AS Name,
Users.Password, Users.OrderPerson, Users.ApproverPerson,
Users.ReceiverPerson, Users.AdminPerson, Users.Active FROM Users WHERE
(((Users.Active)=Yes)) Or (((Users.Active)=Yes)) ORDER BY Users.Password;
this field only shows colum 2 where the data are:[LastName] & " , " &
[FirstName] AS Name (this form is mamed PASSWORD and I want to open another
form but I want that when I click the Icon of the "orders" form it pulls the
combo1 information, in the "orders"
anybody can help me?
I will apreciate so much, if you need more information please repy to this
group.
Ldiaz
I have a form where the field is Combo1 and it has a source like this:
SELECT Users.UserID, [LastName] & " , " & [FirstName] AS Name,
Users.Password, Users.OrderPerson, Users.ApproverPerson,
Users.ReceiverPerson, Users.AdminPerson, Users.Active FROM Users WHERE
(((Users.Active)=Yes)) Or (((Users.Active)=Yes)) ORDER BY Users.Password;
this field only shows colum 2 where the data are:[LastName] & " , " &
[FirstName] AS Name (this form is mamed PASSWORD and I want to open another
form but I want that when I click the Icon of the "orders" form it pulls the
combo1 information, in the "orders"
anybody can help me?
I will apreciate so much, if you need more information please repy to this
group.
Ldiaz