Unbound form question

[Fred Wilson]

Hello,

Access 2002.

I have a form (unbound)frmReportTool that has sever combobox that have
independent queries set for each one of them based off of a single table.

My table is populated by clearing all records and them importing
information from a CSV file. The database the CSV file comes from is not
normalized and does not use primary keys. In short I am making due
with what I have.

Anyway, if frmReportTool is open when I run the procedure to import the
CSV files I get an error because the History Table info is being used to
populate the comboboxes. Short of closing this form at the beginning of
this procedure and then reopening it, how can I get the procedure to run?

Thanks,
Fred

 

[Arvin Meyer]

You can open the form in an unbound state, that is with no recordsource and
the controls also unbound. Then set the recordsource of the form and the
ComtrolSource of all the controls on that form. A bit more work in coding,
but you'll avoid the error.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access