Form refuses to close?!

[robjones23]

Hi,

I've got a database with a linked table to a CSV file which is automatically extracted from some logging software. The Database is used to search for text strings (e.g. "example") within several fields wichin the automated extract and then show the results with any duplicated instances taken out (via an append to table query which is indexed with no duplicates).

So:

Text is entered
FieldA is looked through for a match, if a match is found the whole record gets appended to the Append table.
FieldB is looked through and if a match is found the whole record (including field A) is appended, however if the match has already been found in A, then the record is not copied.
It does this for several fields and then you get a table which is every record containing the searched for text with no duplicates.
This table is then displayed as a subform on another form in it's "table" view.

The form I'm trying to close is the form which contains the above subform.

I've tried:

A macro with close -> form -> formname which doesn't work.
Code:
Private Sub Toggle2_Click()
On Error GoTo Err_Toggle2_Click


DoCmd.Close

Exit_Toggle2_Click:
Exit Sub

Err_Toggle2_Click:
MsgBox Err.Description
Resume Exit_Toggle2_Click

End Sub

Which also doesnt work!

HOWEVER, just to make things interesting, if I click to view the form design, then run the form again, it will close fine using either method. It just seems not to work on the initial run of the text search which then opens the form displaying the subform.

Any ideas?? I can't understand why it won't work.

Cheers - Hope I explained it ok

 

[robjones23]

lol I feel daft!

I figured out that I'd set the form with the subform to open as read only so the form couldn't close.