Form -> Subform with list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a bounded Text Box (country).
I have a sub_form with an unbounded list (city)...

Every works well but navigation.

How can I update the list into the subform every time I click a button in
the in the Navigation Buttons Bar (fist record, previus record, next record,
last record)???

Thnks for your help!
 
Sounds like you need to requery your listbox. In the On_Current event of your
main form put;

Me!NameOfYourSubform!NameOfYourListbox.Requery

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Subform record gets modified when closing form 3
Access Main form/Subform Navigation 0
Form and subform buttons HELP PLEASE 8
subform entry makes new form record 4
Access2000: Synchronizing forms 6
setfocus on form control, not subform 4
Macro doesn't work first time form is opened. 2
new record in subform 1

Back
Top