Refreshing forms

[macca]

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

 

[Naresh Nichani MVP]

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

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.

 

[macca]

Thanks Naresh
Your time is greatly apprecciated
Macca