Refreshing listbox/appending to a query

[Access_Help]

I need help with two issues:


1) I have a tabular form which has a list box and a textbox.

The textbox concats values from the listbox.

When I scroll down to the next record, the listbox and textbox shows the values from the previous record and these values are replicated to all records.

I have applied the: Me.List14.Requery line on the click event of a button but it does not deselect the listbox values from the current record.

2) I need to append the values from the textbox into the query, I can reference the query field to the textbox, but would that save the values to the query next time I open the form?

 

[theDBguy]

Hi. Sounds like you're using an unbound control(s). Is that correct? Also, is your form in Continuous View? Can you post a screenshot?

 

[Access_Help]

Hi. Sounds like you're using an unbound control(s). Is that correct? Also, is your form in Continuous View? Can you post a screenshot?

The textboxes were unbound, thank you, problem fixed.

 

[theDBguy]

The textboxes were unbound, thank you, problem fixed.

Hi. You're welcome. Glad to hear you got it sorted out. Good luck with your project.