S
SueK
Hi,
I have a subform that lists the names of samples that are related to the
sample on the main form. On the subform I have a hyperlink to one of two
forms which are supposed to open up filtered to the name on the subform.
Ie:
Main Form ----- sample 1
Subform-------sample 5... link to filter form 1 sample5
-------sample10... link to filter form 1 sample10
-------sample15... link to filter form 2 sample15
So this seems to work okay for filter form 1
but if I open something in filter form 1 and then try to opening something
in filter form 2 I get a empty form with the error "name?" in all the fields.
I can close out of the filter form, but then I can't close the main form or
move to the next record, I get and error message that asks me to stop code,
and if I hit no the form comes back but I can't move. If I hit yes then I get
the error message popping up again in an endless loop.
The only way to get out is to go to task manager and stop the program
entirely.
I'm filtering using a macro that occurs when the filtered form opens:
[name_seqlong]=[Forms]![SeqInfo]![RecordLinksSubform].[Form]![NameToLinkTo]
it's the same macro for both just subsitute the name at the start for the
name that links in the other file.
I also have an unfilter macro that occurs when I exit the popup form, so
that it shows all the record, and I don't get errors when I look at the next
sample.
Why does this seem to work just fine for one form and not the other?
Help!
Thanks.
I have a subform that lists the names of samples that are related to the
sample on the main form. On the subform I have a hyperlink to one of two
forms which are supposed to open up filtered to the name on the subform.
Ie:
Main Form ----- sample 1
Subform-------sample 5... link to filter form 1 sample5
-------sample10... link to filter form 1 sample10
-------sample15... link to filter form 2 sample15
So this seems to work okay for filter form 1
but if I open something in filter form 1 and then try to opening something
in filter form 2 I get a empty form with the error "name?" in all the fields.
I can close out of the filter form, but then I can't close the main form or
move to the next record, I get and error message that asks me to stop code,
and if I hit no the form comes back but I can't move. If I hit yes then I get
the error message popping up again in an endless loop.
The only way to get out is to go to task manager and stop the program
entirely.
I'm filtering using a macro that occurs when the filtered form opens:
[name_seqlong]=[Forms]![SeqInfo]![RecordLinksSubform].[Form]![NameToLinkTo]
it's the same macro for both just subsitute the name at the start for the
name that links in the other file.
I also have an unfilter macro that occurs when I exit the popup form, so
that it shows all the record, and I don't get errors when I look at the next
sample.
Why does this seem to work just fine for one form and not the other?
Help!
Thanks.