Use text box results as the criteria in a query and then display results

[Bippa88]

Morning,



I'm new to both Microsoft Access and these forums. I've tried to find a solution for my problem but either I don't know what I'm looking for, or I'm on the wrong path.

I have a form that I wish people to enter a 8 digit number. I then need this 8 Digit number to be the criteria in a particular field of my query. After finding all the relevant results, I then need all the results displayed.

Any help would be appreciated.

[June7]

For one method, review:
http://datapigtechnologies.com/flash...tomfilter.html
http://datapigtechnologies.com/flash...mtoreport.html

[Bippa88]

June7,


Thanks for posting that. What you posted is on the right track, but I should have been more specific in my original post. I'll give you a run down of what i'm trying to achieve:


1) You enter a particular value into a text box, it needs to be a text box as I noticed the combo box lets you only select ONE instance of the SAME value. I need my text box to pass the string on to allow the query to find instances where the number is duplicated.


i.e I enter '123456' into my text box. I hit search. Search activates the query and passes the textbox value into the search/query. The query goes to a column called CompanyNumber in a table called CompanyData, finds all records that have the company number '123456,' and returns in the combo box ALL the relevant results from another column called CompanyProductOrder. The user can then select from the combo drop down WHICH CompanyProductOrder they wish to use.


2) That when the user selects a different value in CompanyProductOrder, it doesnt update any of the other Combo Box Results.


I hope this makes sense. As I said, i'm not the most proficient Access user and am stumbling in the dark at the moment.




Thanks again.

[June7]

1. A multi-column combobox will allow display of both CompanyNumber and CompanyProductOrder fields for users to make selection
Alternatively, the list displayed in CompanyProductOrder can be dependent on CompanyNumber entry into text or combobox. Review:
http://datapigtechnologies.com/flash...combobox2.html
http://datapigtechnologies.com/flash...combobox3.html

2. Don't understand the statement.