Refreshing Combo box Record Source

[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.

 

[Marshall Barton]

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?

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.