Refreshing forms

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

Guest

I have a form with 3 combo boxes that the user selects then runs a report. I would like the form to return to its default state with out having to close it and reopen it again. Any help is appreciated
Thanks
 
Hi:

One way to do this is to for these combos change the "Row Source" SQL to
have the ID column second and the text column first. Also change the "Column
Widths" property so the first column is visible and second is not (since
first column has the text). Also change the Bound Column to 2 (so the ID
column is saved to database). Now on a form you can combine the values
directly using the Value property of the Combo Box.

Hope this helps!

Regards,

Naresh Nichani
Microsoft Access MVP



macca said:
I have a form with 3 combo boxes that the user selects then runs a report.
Click to expand...
I would like the form to return to its default state with out having to
close it and reopen it again. Any help is appreciated.
 
Back
Top