Search All Subforms-CrossPost

[Robert Jacobs]

Please Help!

I have read over and over again to go to Allen Browne's website to
filter subforms, but I just don't understand it, and I can't get it to
work in my situation. Any advice is very appreciated.

I have 2 forms. Mainform=Customers Subform(linked)=Service
Requests.

The two forms have a one to many relationship (many service requests
per customer) and are related by customer number (auto number that
automatically is filled in subform to match field on mainform). Each
service request has a txtBox for TicketID. I want to be able to
search through all of the TicketIDs in all of the customer's service
requests (TicketID is not an auto number and can't be used as primary
key-it is a number typed from a tablet of paper with a number at the
top-there could be multiple instances of this number if he orders a
new tablet of paper and it starts with the same number-very very small
company). I have created another subform (which may not be needed,
but I thought it might help) that just displays the TicketIDs (all
TicketIDs related to the customer number) from the service request
table on the mainform.

The search button that the wizard creates will not even search the
TicketIDs on the current customer ID's page, none the less searching
through all customer's pages to find the corresponding Ticket IDs. And
when I put the search button in the subform, it will only search for
TicketIDs related to the current customer number (which I like)

Is what I am trying to do possible? I am VERY new to Access (about 2
weeks into it) and just want to make this database for my family's
Clock Shop. Thank you for any help you can provide!

[Allen Browne]

See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robert Jacobs" <ro************@gmail.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.com...

Please Help!

I have read over and over again to go to Allen Browne's website to
filter subforms, but I just don't understand it, and I can't get it to
work in my situation. Any advice is very appreciated.

I have 2 forms. Mainform=Customers Subform(linked)=Service
Requests.

The two forms have a one to many relationship (many service requests
per customer) and are related by customer number (auto number that
automatically is filled in subform to match field on mainform). Each
service request has a txtBox for TicketID. I want to be able to
search through all of the TicketIDs in all of the customer's service
requests (TicketID is not an auto number and can't be used as primary
key-it is a number typed from a tablet of paper with a number at the
top-there could be multiple instances of this number if he orders a
new tablet of paper and it starts with the same number-very very small
company). I have created another subform (which may not be needed,
but I thought it might help) that just displays the TicketIDs (all
TicketIDs related to the customer number) from the service request
table on the mainform.

The search button that the wizard creates will not even search the
TicketIDs on the current customer ID's page, none the less searching
through all customer's pages to find the corresponding Ticket IDs. And
when I put the search button in the subform, it will only search for
TicketIDs related to the current customer number (which I like)

Is what I am trying to do possible? I am VERY new to Access (about 2
weeks into it) and just want to make this database for my family's
Clock Shop. Thank you for any help you can provide!

[Robert Jacobs]

On Apr 6, 9:28 am, "Allen Browne" <[e-mail]:

See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robert Jacobs" <[e-mail] in message

news:11**********************@b75g2000hsg.googlegr oups.com...

Please Help!

I have read over and over again to go to Allen Browne's website to
filter subforms, but I just don't understand it, and I can't get it to
work in my situation. Any advice is very appreciated.

I have 2 forms. Mainform=Customers Subform(linked)=Service
Requests.

The two forms have a one to many relationship (many service requests
per customer) and are related by customer number (auto number that
automatically is filled in subform to match field on mainform). Each
service request has a txtBox for TicketID. I want to be able to
search through all of the TicketIDs in all of the customer's service
requests (TicketID is not an auto number and can't be used as primary
key-it is a number typed from a tablet of paper with a number at the
top-there could be multiple instances of this number if he orders a
new tablet of paper and it starts with the same number-very very small
company). I have created another subform (which may not be needed,
but I thought it might help) that just displays the TicketIDs (all
TicketIDs related to the customer number) from the service request
table on the mainform.

The search button that the wizard creates will not even search the
TicketIDs on the current customer ID's page, none the less searching
through all customer's pages to find the corresponding Ticket IDs. And
when I put the search button in the subform, it will only search for
TicketIDs related to the current customer number (which I like)

Is what I am trying to do possible? I am VERY new to Access (about 2
weeks into it) and just want to make this database for my family's
Clock Shop. Thank you for any help you can provide!- Hide quoted text -

- Show quoted text -

Continuing conversation at:
http://groups.google.com/group/micro...c2a882649f342e