I have created a form based on a query where I have to give the parameters for a date range and a choice of 4 locations to run i. When the form opens after the query runs the field for the date and the field for the location both have dropbox arrows on the side. I can't choose anything from those arrows, nor do I want to, but how do I get rid of those dropbox arrows on the form.
Kevin Robertson
@Reply 4 years ago
First of all you mean a Combo Box, not a Dropbox.
You will need to change the control from a Combo Box to a Text Box.
You will most probably have to make some changes to your query in order to get the value into the Text Box.
Before making these changes make sure you backup the Query and the Form just in case things go wrong (always a good idea) so you can easily revert back to what you had.
Maarten BrusselersOP
@Reply 4 years ago
No, I don't mean a combo box. I get the value of the form fields directly from the query. The result from the query displayed in the form is correct. When I run the query I have to enter the required date range and the location to get the result I want. This works fine. I then use a continuous form to display the result of the query. However, the form then displays the arrow boxes on the right side of the fields that used the parameter results as if you can choose . When you click the arrow a blank appears as the only option. I want to get rid of the arrows boxes.
Kevin Robertson
@Reply 4 years ago
Can you post some screenshots please?
Maarten BrusselersOP
@Reply 4 years ago
Will do tomorrow. It is 8:30 PM here. Thanks for the help.
Maarten BrusselersOP
@Reply 4 years ago
Managed to solve it. In the table I had originally used the Lookup Wizard which inserted a Combo Box in the Lookup field. By setting the field to Textbox and re-entering the field in the form it was solved. Thanks for your help. BTW, Richard was absolutely right in telling us not to use the Lookup Wizard. Lesson learned.
Dan Jackson
@Reply 4 years ago
See Access Evil Stuff @Richard - Can we add this to the list please?
Kevin Robertson
@Reply 4 years ago
Already on the list Dan (Lookup Values)
Dan Jackson
@Reply 4 years ago
Not sure what list you are referring to Kevin. I'm talking about the drop down us mods have listing video and articles to generate the link automatically
Dan Jackson
@Reply 4 years ago
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
TechHelp.