listBox TextBox

  • Thread starter Thread starter Dorian C. Chalom
  • Start date Start date
D

Dorian C. Chalom

I am sorry I am really rusty with Access.
Can someone point me in the right direction here.
I have a ListBox that is tied to a RecordSource and when the user enters a
new entry into the TextBox I want that to be added to the ListBox. How do I
do that?

Thank you All!!!!
 
Dorian

What's the RecordSource for the listbox? It might be a table or it might be
a query.

For your new entry into the textbox to show up, you could add it to the
underlying table that's the RecordSource.

Or, if you are using a ValueList for the listbox's source, you'd have to add
it to that list. NOTE: if you want to make it easier on yourself, and if
you expect the number of items in the list to grow, use the table approach,
not the ValueList approach.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Yes OK the source of the Listbox is a table.
And Yes I figured this is what I needed to do.
What I cannot recall is how to add the record to the table and pouplate the
record.

Can you help?

Thank you.
 
I got it all to work...

Thank you...
Dorian C. Chalom said:
Yes OK the source of the Listbox is a table.
And Yes I figured this is what I needed to do.
What I cannot recall is how to add the record to the table and pouplate
the record.

Can you help?

Thank you.
Click to expand...
 
Dorian

You might post back 'how' you got it to work... other folks coming to the
newsgroup might benefit from see how you did it...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top