Refreshing Combo box Record Source

  • Thread starter Thread starter Marcel K.
  • Start date Start date
M

Marcel K.

Have ComboBox on Form A
ComboBox1.RecordSource =
SELECT ReportID,ReportLongName FROM tblReports;


Open another form - FORM B
add record to tblReports fromForm B
Close Form B

Form A Still open - and now has focus
Q? How can I get the CombBox1 to now see the new entry in
tblReports? A way to fire the recordsource again?

Thanks Marcel K.
 
Marcel said:
Have ComboBox on Form A
ComboBox1.RecordSource =
SELECT ReportID,ReportLongName FROM tblReports;


Open another form - FORM B
add record to tblReports fromForm B
Close Form B

Form A Still open - and now has focus
Q? How can I get the CombBox1 to now see the new entry in
tblReports? A way to fire the recordsource again?
Click to expand...


You need to Requery the combo box, but I'm not sure where in
your form logic you would do that.

If FormA is opening FormB in Dialog mode, then you can do it
immediately after the OpenForm statement.
 
Back
Top