H
hsdaguilar
Hello,
I have a main form called frmPrimary which has fields such as address and a
linked form called frmProjects which has fields such as keyword. (Keyword is
not included in frmPrimary because one address can have many projects and
each has it's own keyword).
On frmPrimary, I have a button called Query which opens frmQuery. On
frmQuery, I have two unbound fields. One allows you to enter the address and
the other allows you to enter the keyword. Either one is supposed to open
frmPrimary.
The unbound address field is working. I did this by creating a query with
the address field and then setting the unbound address field in frmQuery as
the criteria. A macro takes care of the rest by pushing the "ok" button.
The unbound keyword field is not working. I am using the same process. If I
enter anything in the unbound keyword field, a parameter query message pops
up and I have to reenter the keyword. From there it does open frmPrimary to
the correct record (I tested it), but I hate that it asks you to reenter the
info. Can someone please help. Thx.
I have a main form called frmPrimary which has fields such as address and a
linked form called frmProjects which has fields such as keyword. (Keyword is
not included in frmPrimary because one address can have many projects and
each has it's own keyword).
On frmPrimary, I have a button called Query which opens frmQuery. On
frmQuery, I have two unbound fields. One allows you to enter the address and
the other allows you to enter the keyword. Either one is supposed to open
frmPrimary.
The unbound address field is working. I did this by creating a query with
the address field and then setting the unbound address field in frmQuery as
the criteria. A macro takes care of the rest by pushing the "ok" button.
The unbound keyword field is not working. I am using the same process. If I
enter anything in the unbound keyword field, a parameter query message pops
up and I have to reenter the keyword. From there it does open frmPrimary to
the correct record (I tested it), but I hate that it asks you to reenter the
info. Can someone please help. Thx.