I understand the concept of creating a continuous form to view records and adding a button to view a single record in the main form. While it's a practical solution in many cases I need a better solution for large numbers of records. I'd like to add a lookup box to my main form that once an ID is selected from the dropdown, all fields are updated to show the selected record. Is there a lesson that shows this type of combo box?
Reply from Richard Rost:
You could very easily just make a list box or combo box that changes the current record in the form instead of opening up a separate form. This would require some kind of AfterUpdate event. It's a little more advanced than Access 103. There is also the "find a record" option in the combo box wizard. This turns your combo box into a SEARCH box.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.