S
Stockwell43
Hello,
I have a form with a text box to enter a project name. When the project name
is added, the user would click the Add Record button which also requeries the
form. Then when they click on the project list CBO, the project name previous
entered will show. This all works fine except, if the user uses the record
selector on the bottom of the form to scroll through the projects, the form
will show all the different project but the project list CBO stays on the
same project that was last viewed and I don't know how to get it to follow
the with each record. The Project list CBO is an unbound CBO with the
following in the Row source and not sure where the Expr1 is coming from but
it keeps entering that.
SELECT tblprojectinformation.ProjectID, [ProjectName] AS Expr1 FROM
tblprojectinformation ORDER BY [ProjectName];
Thanks!!
I have a form with a text box to enter a project name. When the project name
is added, the user would click the Add Record button which also requeries the
form. Then when they click on the project list CBO, the project name previous
entered will show. This all works fine except, if the user uses the record
selector on the bottom of the form to scroll through the projects, the form
will show all the different project but the project list CBO stays on the
same project that was last viewed and I don't know how to get it to follow
the with each record. The Project list CBO is an unbound CBO with the
following in the Row source and not sure where the Expr1 is coming from but
it keeps entering that.
SELECT tblprojectinformation.ProjectID, [ProjectName] AS Expr1 FROM
tblprojectinformation ORDER BY [ProjectName];
Thanks!!