By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,916 Members | 1,078 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,916 IT Pros & Developers. It's quick & easy.

Query a subform

P: n/a
Hello All,
I am creating a database form that has 5 tabs, with each tab holding a
subform. On the first tab I want to Highlight certain words that appear
in one of the subforms. The words I am looking for are "customer" and
"office".
The main form is called "frm_ro_shop" the subform that I want to query
is called "frm_ro_notes".
I want to look in the subform for "customer" and "office" in the "type"
field of the subform and display the word customer or office on the
first tab and have the word be highlighted.
I tried using dlookup but I cannot figure out how to get dlookup to
reference only the data displayed on the form. This is for an ADP
application so I am a little limited on how I can go about this. Please
help!!

May 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Holmsey wrote:
Hello All,
I am creating a database form that has 5 tabs, with each tab holding a
subform. On the first tab I want to Highlight certain words that appear
in one of the subforms. The words I am looking for are "customer" and
"office".
The main form is called "frm_ro_shop" the subform that I want to query
is called "frm_ro_notes".
I want to look in the subform for "customer" and "office" in the "type"
field of the subform and display the word customer or office on the
first tab and have the word be highlighted.
I tried using dlookup but I cannot figure out how to get dlookup to
reference only the data displayed on the form. This is for an ADP
application so I am a little limited on how I can go about this. Please
help!!

This is the dlookup I have on the ubound control on the first tab
=dlookup("[Type"],"notes_view", "[Type]='Customer")
However this does not limit the data to only what is displayed on the
subform.
There is another field called [incidentNo] that I would like to limit
this dlookup to.

May 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.