Search on a field in a subform?

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

How can I search on a field that is located in a subform?
I would actually like to have a search field contained in
the main form that will search for a field contained in
the subform?

Here is my example:
Main form [FormHelpDesk] contains information on employee
with [PIN] as the master field. The subform
[subformHelpDesk] contains the tickets [TicketNumber]
associated with the [PIN].

How can I search for a [TicketNumber] without first
searching by PIN? Even if I locate first locate the [PIN]
it won't let me do a Ctrl-F to search in the
[TicketNumber] field.

Thanks for your help and Happy Holidays.
 
You could add a drop down list or a list box look-up field
that displays all the fields in a table, place a control
for that new field on your form, and attach to the
controls OnUpdate property a macro or event procedure that
sorts the data by whatever field the user selects from the
drop down list or list box. The results could be stored in
another table as well.
 
Where are you suggesting that I add new field? In the
main form or the subform? I would like to have search
capability that allows me to search for the ticketnumber
without first searching for the PIN.

I could not find an "OnUpdate" property.

Also, I'm not sure why you suggest I sort the data and
store it in another table?

Thanks, grace


Also, I don't think it can be a dropdown field
-----Original Message-----
You could add a drop down list or a list box look-up field
that displays all the fields in a table, place a control
for that new field on your form, and attach to the
controls OnUpdate property a macro or event procedure that
sorts the data by whatever field the user selects from the
drop down list or list box. The results could be stored in
another table as well.
-----Original Message-----
How can I search on a field that is located in a subform?
I would actually like to have a search field contained in
the main form that will search for a field contained in
the subform?

Here is my example:
Main form [FormHelpDesk] contains information on employee
with [PIN] as the master field. The subform
[subformHelpDesk] contains the tickets [TicketNumber]
associated with the [PIN].

How can I search for a [TicketNumber] without first
searching by PIN? Even if I locate first locate the [PIN]
it won't let me do a Ctrl-F to search in the
[TicketNumber] field.

Thanks for your help and Happy Holidays.
.
Click to expand...
.
Click to expand...
 
Back
Top