Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

populate listbox with recordset

populate listbox with recordset

populate listbox with recordset

New to the game but moderately versed in vba.

Many discussions on subject and am confident I can make a solution work. My question is how to incorporate values from a form control with the recordset to populate a table?

I filter values from one combobox to another which filters to a third that I then add to a list. All is good using SQL in a AfterUpdate event that changes the control rowsource, but.... my spin button on the form that designates the quantity does not want to mesh with the SQL for the listbox. I get the values in the listbox except the one on the form so Im looking at this recordset thing which I am just now beginning to wrap my head around.

Ant suggestions on concatenating a form control value with Sql, Recordsets, Arrays, anything I missed?

RE: populate listbox with recordset

You will probably get better help here: forum702: Microsoft: Access Forms
since this isn't really a database connectivity issue.

Beir bua agus beannacht!

RE: populate listbox with recordset

So, when I figure it out I win, and with the help of others I am grateful. Still a win. Thanks for the direction.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close