refreshing form

  • Thread starter georgeg via AccessMonster.com
  • Start date
G

georgeg via AccessMonster.com

I have a form with a combo box field that references a table so we can keep
information in the field uniform (i.e. "Place",not "Pl."). At times when
filling out the form there is a new word not in the table being refereced to
by the combo box.

From the main input form, I select a button named "DB Admin"; it opens a form
with buttons to all the different tables containing information that we want
to keep uniform. I open the form for the referenced table, add the new word,
close the form, and close the "DB Admin form". I am now back to the main
input form. When I look at the combo box field for the newly entered word,
it is not there.

I close the main input form, re-open it, go to the record, select the combo
box field and the new word is there. Is there a way to refresh the main
input form, and or a way to get around having to close the main input form
and re-opening it? Thanks for the help!!
 
G

George Nicholson

After the new entry has been added to the table:
Me.MyCombo.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

Top