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

Form with subforms

P: n/a
Dear community

I have recently created an MS-Access database to store and process
the various phone numbers, phone devices we use in our hospital. I`m
experiencing a problem creating a specific form.
In that form I need to find a total count of records in a table
subject to an alternating criterion. The criterion is given from a
third table. How can I create a dynamic query that accepts a criterion
from an edit box?
Any help would be greatly appreciated!
Best regards

George Papadopoulos
Hippocrates General Hospital
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
George,

It sounds like you need something similar to the way you enter strat and end
dates.

Create a pop-up form with a textbox for entering your criteria. Put this
expression in the criteria of your query:
Forms!NameOfPopupForm!NameOfTextbox on pop-up form.

Note that the pop-up form must be open when the query runs!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"George Papadopoulos" <di*********@freemail.gr> wrote in message
news:f2**************************@posting.google.c om...
Dear community

I have recently created an MS-Access database to store and process
the various phone numbers, phone devices we use in our hospital. I`m
experiencing a problem creating a specific form.
In that form I need to find a total count of records in a table
subject to an alternating criterion. The criterion is given from a
third table. How can I create a dynamic query that accepts a criterion
from an edit box?
Any help would be greatly appreciated!
Best regards

George Papadopoulos
Hippocrates General Hospital

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.