Can I click on a line and have popup window?

[Rod ElEd]

I have a database with a field that contains multiple phrases with each one
showing up on a separate line in the form view.
Is it possible to make it so that a database user in form view can click on
one of the lines (phrase) in the field and have a definition appear that
explains the phrase?

 

[KARL DEWEY]

Build an Explaination table with two fields - Phrase & Explaination.
Build a query using the field as criteria on the Phrase field of the
Explaination table like this --
[Forms]![YourFormName]![YourTextBoxName]
Use that query to feed a form you set as a Popup.
In design view of the phrase form create an event or call a macro that opens
the Popup form on double-click.

 

[Rod ElEd]

Karl, I have the Explanation table with two fields - Phrase & Explanation.

I'm not sure how to accomplish the next tasks: build a query using the field
(which field) as criteria (what does this mean?) Do I build this query while
in the original database or in the Explanation database?
How do I accomplish this > [Forms]![YourFormName]![YourTextBoxName] ?

How do I "use that query to feed a form you set as a Popup"?

Sorry I sound so ignorant, but I just don't understand what to do.
Thanks for your help.

Build an Explaination table with two fields - Phrase & Explaination.
Build a query using the field as criteria on the Phrase field of the
Explaination table like this --
[Forms]![YourFormName]![YourTextBoxName]
Use that query to feed a form you set as a Popup.
In design view of the phrase form create an event or call a macro that opens
the Popup form on double-click.
--
KARL DEWEY
Build a little - Test a little

I have a database with a field that contains multiple phrases with each one
showing up on a separate line in the form view.
Is it possible to make it so that a database user in form view can click on
one of the lines (phrase) in the field and have a definition appear that
explains the phrase?

 

[KARL DEWEY]

Do I build this query while in the original database or in the Explanation
database?
Are you confusing databases with tables? All of this is to be one database.
This is your query too be used as record source for the popup form. Edit it
putting your form name and the name of your textbox that displays the phrase.
SELECT Explanation.Phrase, Explanation.Explanation
FROM Explanation
WHERE (((Explanation.Phrase)=[Forms]![YourFormName]![YourTextBoxName]));

--
KARL DEWEY
Build a little - Test a little

Karl, I have the Explanation table with two fields - Phrase & Explanation.

I'm not sure how to accomplish the next tasks: build a query using the field
(which field) as criteria (what does this mean?) Do I build this query while
in the original database or in the Explanation database?
How do I accomplish this > [Forms]![YourFormName]![YourTextBoxName] ?

How do I "use that query to feed a form you set as a Popup"?

Sorry I sound so ignorant, but I just don't understand what to do.
Thanks for your help.

Build an Explaination table with two fields - Phrase & Explaination.
Build a query using the field as criteria on the Phrase field of the
Explaination table like this --
[Forms]![YourFormName]![YourTextBoxName]
Use that query to feed a form you set as a Popup.
In design view of the phrase form create an event or call a macro that opens
the Popup form on double-click.
--
KARL DEWEY
Build a little - Test a little

I have a database with a field that contains multiple phrases with each one
showing up on a separate line in the form view.
Is it possible to make it so that a database user in form view can click on
one of the lines (phrase) in the field and have a definition appear that
explains the phrase?

 

[Rod ElEd]

You are correct: I was confusing databases with tables.

OK, I have two tables in the same DB, one called BOOKS containing a field
named "notes". The "notes" field contains phrases that I will want to lookup.
Then I have a second table called EXPLANATION that contains two fields,
"phrase" and "explanation".

I want to be able to click on a phrase in the "notes" field of BOOKS and
have it lookup the phrase in the EXPLANATION table and display the
information in the "explanation" field that matches the phrase.

Do I want to select the EXPLANATION table, select the queries tab under
objects, and then create query by using wizard?

database?
Are you confusing databases with tables? All of this is to be one database.
This is your query too be used as record source for the popup form. Edit it
putting your form name and the name of your textbox that displays the phrase.
SELECT Explanation.Phrase, Explanation.Explanation
FROM Explanation
WHERE (((Explanation.Phrase)=[Forms]![YourFormName]![YourTextBoxName]));

--
KARL DEWEY
Build a little - Test a little

Karl, I have the Explanation table with two fields - Phrase & Explanation.

I'm not sure how to accomplish the next tasks: build a query using the field
(which field) as criteria (what does this mean?) Do I build this query while
in the original database or in the Explanation database?
How do I accomplish this > [Forms]![YourFormName]![YourTextBoxName] ?

How do I "use that query to feed a form you set as a Popup"?

Sorry I sound so ignorant, but I just don't understand what to do.
Thanks for your help.

Build an Explaination table with two fields - Phrase & Explaination.
Build a query using the field as criteria on the Phrase field of the
Explaination table like this --
[Forms]![YourFormName]![YourTextBoxName]
Use that query to feed a form you set as a Popup.
In design view of the phrase form create an event or call a macro that opens
the Popup form on double-click.
--
KARL DEWEY
Build a little - Test a little


:

I have a database with a field that contains multiple phrases with each one
showing up on a separate line in the form view.
Is it possible to make it so that a database user in form view can click on
one of the lines (phrase) in the field and have a definition appear that
explains the phrase?

 

[KARL DEWEY]

You need to be using a query to a form to interface with your tables.
In the form that displays your Notes field add an event or call a macro to
open the form that is your popup. The SQL statement I posted for your is the
query to use as souce for thepopup form.

SEQUENCE ---
Form1 is open displaying field Notes. Double-clicking the field triggers an
event or macro to open the popup form fed by a query that has criteria to
match Notes field on form1. The popup displays the explaination and stays
in focus until closed.
--
KARL DEWEY
Build a little - Test a little

You are correct: I was confusing databases with tables.

OK, I have two tables in the same DB, one called BOOKS containing a field
named "notes". The "notes" field contains phrases that I will want to lookup.
Then I have a second table called EXPLANATION that contains two fields,
"phrase" and "explanation".

I want to be able to click on a phrase in the "notes" field of BOOKS and
have it lookup the phrase in the EXPLANATION table and display the
information in the "explanation" field that matches the phrase.

Do I want to select the EXPLANATION table, select the queries tab under
objects, and then create query by using wizard?

Do I build this query while in the original database or in the Explanation

database?
Are you confusing databases with tables? All of this is to be one database.

I'm not sure how to accomplish the next tasks: build a query using the field (which field) as criteria (what does this mean?)

This is your query too be used as record source for the popup form. Edit it
putting your form name and the name of your textbox that displays the phrase.
SELECT Explanation.Phrase, Explanation.Explanation
FROM Explanation
WHERE (((Explanation.Phrase)=[Forms]![YourFormName]![YourTextBoxName]));

--
KARL DEWEY
Build a little - Test a little

Karl, I have the Explanation table with two fields - Phrase & Explanation.

I'm not sure how to accomplish the next tasks: build a query using the field
(which field) as criteria (what does this mean?) Do I build this query while
in the original database or in the Explanation database?
How do I accomplish this > [Forms]![YourFormName]![YourTextBoxName] ?

How do I "use that query to feed a form you set as a Popup"?

Sorry I sound so ignorant, but I just don't understand what to do.
Thanks for your help.



:

Build an Explaination table with two fields - Phrase & Explaination.
Build a query using the field as criteria on the Phrase field of the
Explaination table like this --
[Forms]![YourFormName]![YourTextBoxName]
Use that query to feed a form you set as a Popup.
In design view of the phrase form create an event or call a macro that opens
the Popup form on double-click.
--
KARL DEWEY
Build a little - Test a little


:

I have a database with a field that contains multiple phrases with each one
showing up on a separate line in the form view.
Is it possible to make it so that a database user in form view can click on
one of the lines (phrase) in the field and have a definition appear that
explains the phrase?