having to explicitly select field

[joeblow2]

In a form that updates a table, it seems that I have to click on (select) each of the fields in list boxes for Access to accept the fields and update the table. Otherwise it complains that a related record is required. (I am --through code--populating the list boxes so I am not explicitly selecting the fields.)
How do I avoid doing that.

Thanks.

 

[ajetrumpet]

you can avoid the message by either changing your relationships, or the process by which you are pulling the data.

The information you provided about the problem too, is a bit vague.

 

[missinglinq]

The entire purpose of a listbox is to provide the user with a means to select data. If I'm reading this correctly, you're upset because you actually have to select data from the listbox for the from to utilize it! As Adam said, if you don't want the user to have to select data from the listbox, you need to use some other method besides a listbox to pull your data, such as a query!

 

[joeblow2]

Thank you Adam and missinglinq.