On Got Focus - Microsoft Access Forum - Computer Learning Zone

24 minutes ago: Please note that the webserver will soon get its weekly reboot at 4:00 am Eastern Time. You may continue to use the site as normal, but you will be logged off at that time. You should be able to log right back on immediately, however. If you are in the process of placing an order, please make sure to complete it as quickly as possible, or come back after the reboot. Thank you. Sorry for any inconvenience. Dismiss

Free Lessons
Courses
Seminars

TechHelp
Fast Tips
Templates

Topic Index
Forum
ABCD

Home Courses TechHelp Help Contact Merch Join Order Logon Forums


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

On Got Focus

Andrea Buckridge

4 years ago

I have forms that are related in a cascading effect. For example, I have TripT which can be related to up to 5 records from LoadT and each LoadT record can have up to 2 LoadInfoT records. Is there a way to make all Loads related to a trip show up in a list box on my TripF and all LoadInfo records related to a load show up in a list box on my LoadF? I am sure there is. However I am having a hard time figuring out how to make it only show the LoadInfo records for that specific load. Also I have a button on the LoadF to add a LoadInfo record, how do I get the list box to update as soon as the loadInfo record has been created?

	Kevin Robertson @Reply 4 years ago
To limit the List Box simply add a Where Condition to the Row Source of the List Box. SQL with Access SQL Seminar 1 To update the List Box use the Requery Method: `Forms!FormName!ListBoxName.Requery`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View