How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Michael Hannigan Your Own Question
Michael Hannigan
Michael Hannigan, Office Specialist
Category: Microsoft Office
Satisfied Customers: 11697
Experience:  25+ Years Experience in Computers and Electronics. Microsoft Certified MCSE, MCDBA, MCP, Microsoft Partner
Type Your Microsoft Office Question Here...
Michael Hannigan is online now
A new question is answered every 9 seconds

I am having trouble with an Access form. I have form based

Customer Question

I am having trouble with an Access form. I have form based on a basic query that is built from only one table. I have a combo box that I am trying to get to filter on a certain field. This field has several duplication of records. I am having the user pick a drug name from a form, and that choice will need to bring up all records pertaining to that choice. Right now, I have the combo box creating distinct records, so it does pull up the first record relating to the drug, but it doesn't filter just those drug results only. Does this need to be removed from the row source? I am currently studying form design so I am a bit new at this. I appreciate any help you can provide.
Thank you!
Malesa Smith
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Michael Hannigan replied 1 year ago.

Hello. My name is***** can help you with your question.

I think I understand what you're trying to do. And it sounds like you have a table with drug information in each record. And you are trying to select all the records that are associated with a particular value for a particular field.

Where I lost you was when you said that the combo box is creating distinct records and it pulls up the first record relating to the drug but it doesn't filter just those drug results only.

This doesn't sound something like a form you would typically be doing with only one table – is a single table a requirement of what you're doing? Ideally, what we would want is for example a table with the names of drugs in them so that there would be one record for each drug name and then have other fields that tell us what other pieces of information from other tables go with that drug. That way if you pull up a drug and the drug would be a unique value in that table – then you could put pull up information and other tables associated with it whether those tables be one with side effects another with customers who take it another with prices and so on. And by doing this you can associate one drug with many other pieces of information. Does that sound like what you are trying to do?

Customer: replied 1 year ago.
Hi Mike,
Yes this sounds correct. I thought I had answered you once, so I'm hoping this email gets to you. I created a master list table of unique drugs yesterday and linked it to my query that is connected to the form. Is this correct? What would be my next step?
Malesa XXX
Expert:  Michael Hannigan replied 1 year ago.

Now you would need tables related to that one that have whatever other information you need. You should have a list of attributes that you want to record for each drug and then and then use a relationship between the tables to attach to those records to each other. You had mentioned that it's already based on a query so you also the option of using those query fields in a form as well. There are many potential variables here in terms of how to do things.

I'm still not sure what you mean about "it doesn't filter just those drug results only. Does this need to be removed from the row source?"

Related Microsoft Office Questions