I forgot to mention that the reason that your info was repeated is that you did not have Control Source named in the combo box property window--it's your key field.
You can "add" an unbound combo box to your form, using the tools wizard. You bind it to a data set thusly: In the combo box properties window under the data tab, Select table/query for Row Source Type. Click Row Source and then click the ellipsis (...) Add the table to the QBE grid that you...
I needed to do something similar--open a second form that displayed information based on the current record on the first form. Rather than use the click event on the control(in my case it was UserID), I used a command button that accomplished the same thing. The linking field that the second...
I created a query-based report that is sorted by due date. (The due date is just a date field from the table used in the query.) 6/10/01 sorts before 6/2/01. What's the easiest approach to correct this problem?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.