Here are some sample mdb's that might help, there are others on this site http://www.rogersaccesslibrary.com/TableOfContents3.asp or http://www.rogersaccesslibrary.com/
ComboChoosesRecord.mdb ( beginner ) This illustrates how to have a combo box in which you can choose a value and have that record appear in the form. CascadingComboBoxes.mdb ( beginner ) This sample illustrates how to restrict the value of one combo box based on the value of another. CascadingComboInSubform.mdb ( intermediate ) Illustrates how to use Cascading Comboboxes in a continuous subform. --- In [email protected], Beulah Florence <[EMAIL PROTECTED]> wrote: > > I did not know if I could email to your id, i am sorry if i shouldnt have, but i needed the answer for my question. > > I have a table "Project". There is a field Project name and some other fields that have a boolean value/check box values. The user needs to have an option of choosing the field that should be queried upon. For example the fields, I am talking abt are: F1, F2, F3, F4. I will have these as the value list for Combo box. And When the user selects one of it, will I be able to display all those project names that have a true value for that particular field. > > I will be waiting to hear from you. > > Thank you > Florence > > A smile is the light in your window that tells others that there is a caring, sharing person inside.Keep SMILING. > > > > ----- Original Message ---- > From: rchlon9 <[EMAIL PROTECTED]> > To: [email protected] > Sent: Thursday, June 28, 2007 3:06:12 PM > Subject: [Access VBA Central] Re: Field Level Queries > > Can you explane your question in a little more detail, i am sure what > you are trying to achieve is possible but i need to understand better > what exactly you need before advising you more. > > --- In AccessVBACentral@ yahoogroups. com, Beulah Florence > <itssmily@ .> wrote: > > > > Can I perform a query using an input from the user as a field on > which the query is written? > > > > It is very urgent. Please respond quickly if anyone can help. > > > > Florence > > > > A smile is the light in your window that tells others that there is > a caring, sharing person inside.Keep SMILING.
