Show plus sign in form

[BenEl via AccessMonster.com]

Hi. I am trying to create a form containing a parent / child relationship. I
would like the form contain 2 subforms in datasheet view (the parent table -
POSITION - and the child table - CANDIDATE -). This is not a problem. The
problem I am having is that I would like the tables to have the plus / minus
sign displayed as they do in the table. How can I get the plus / minus sign
to be displayed in the form?

Thanks.

 

[Jeff Boyce]

For what purpose?

You're describing a "how", but not much about the "what" ... what business
need are you trying to solve by showing that "+"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[BenEl via AccessMonster.com]

It's a HR dbase. There is a table of Job Positions, a table of General
Candidates. One Position can have many Candidates and one Candidate can apply
to many positions. I would like both of these tables displayed on the form. I
would like the user to be able to see the key identifying fields of the two
tables and click onto the "+" to quickly see who has applied for a position
or vice versa. I will set the code so that the user can double click on the
Candidate or Position ID and open the detail form.

Thanks.

For what purpose?

You're describing a "how", but not much about the "what" ... what business
need are you trying to solve by showing that "+"?

Regards

Jeff Boyce
Microsoft Access MVP

Hi. I am trying to create a form containing a parent / child relationship.
I

[quoted text clipped - 8 lines]

Thanks.

 

[Jeff Boyce]

It sounds like you are trying to work directly in the tables ... that's how
you'd do it with spreadsheets, but it's neither necessary nor a good idea
when using Access.

Have you looked into using main form/subform construction?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

It's a HR dbase. There is a table of Job Positions, a table of General
Candidates. One Position can have many Candidates and one Candidate can
apply
to many positions. I would like both of these tables displayed on the
form. I
would like the user to be able to see the key identifying fields of the
two
tables and click onto the "+" to quickly see who has applied for a
position
or vice versa. I will set the code so that the user can double click on
the
Candidate or Position ID and open the detail form.

Thanks.

For what purpose?

You're describing a "how", but not much about the "what" ... what business
need are you trying to solve by showing that "+"?

Regards

Jeff Boyce
Microsoft Access MVP

Hi. I am trying to create a form containing a parent / child
relationship.
I

[quoted text clipped - 8 lines]

Thanks.

 

[BenEl via AccessMonster.com]

Yes - I think I'm going to end up doing a main form for positions and a sub
with Candidates and a main form with Candidates and a sub with positions...
Not exactly how I envisioned it, but it will work.

It sounds like you are trying to work directly in the tables ... that's how
you'd do it with spreadsheets, but it's neither necessary nor a good idea
when using Access.

Have you looked into using main form/subform construction?

Regards

Jeff Boyce
Microsoft Access MVP

It's a HR dbase. There is a table of Job Positions, a table of General
Candidates. One Position can have many Candidates and one Candidate can

[quoted text clipped - 27 lines]