populate data in listbox based on textbox value chang

[Atoga]

Hi All,
I am setting up data entry forms. I would like to populate data in listboxes based on change in textbox value. So for example when I have a course in the textbox in my data entry form (control source is the course list) I can see the list of participants of that course appearing in the list box under the text box.


I am quite new to Access. Could someone help me with this?
Cheers

[June7]

This is dependent (cascading) list or combo boxes. Review http://www.datapigtechnologies.com/f...combobox2.html

Be aware this will not work nice with continuous or datasheet forms.

[Atoga]

Thanks June7,
What if my listbox is dependent on a textbox?
I added the Where criteria to the listbox, the content of the listbox shows up correctly (i.e. according to what I have in the textbox) when I run the query (row source Select Qry), but it does not show up correctly in the listbox in the form itself. I added a Requery macro AfterUpdate (textbox), but it still does not work...what do you think the problem is? Thanks

[June7]

Doesn't matter if first control is textbox or combobox or listbox, technique is the same.

I don't use macros, only VBA.

I don't know why it doesn't work. Would have to know more about data structure, form setup, listbox properties. If you want to provide db, follow instructions at bottom of my post.

[accedeholdings]

I agree with June, working with macros sometimes mess up the database. I'd rather do it manually than using macros.

[Atoga]

Hi June7 and accedeholdings,
Pls find it attached.
Cheers

[orange]

A few things to consider:

Use a naming convention that is alphanumeric and "_" underscore only. No \& etc.
In your junction table, you only need the ID fields from the related tables. I'd suggest a unique compound index as shown to prevent duplicates.

Here is a list of reserved words in Access.

[Atoga]

Thanks, I made the changes. However, this still have not solved my issue of the Skills listbox on the Dataentry form not updating when I move between records of Course/Qualification (see above, at the beginning of the thread). Can you please help me with this?

[June7]

The query references a textbox or field named Course/QualifID. This is a field referencing itself for its criteria. The query needs to reference the textbox on the form which is named Course/Qual.

Why isn't Course/Qualification a combobox instead of textbox?

The VBA procedure is not associated with the textbox. The textbox event has an Embedded Macro which opens QrySkillList.