Trying to use a form to return multiple fields from a query

[gentrym]

I have already made a query with all the information needed. What I am trying to do is create a form where a user can open the database and enter a unique number and have information from 10 fields associated with that number show. And here's the kicker (if you couldn't tell by how I posed the question), I'm quite the novice at Access and don't really know all the coding techniques you guys do. I'm sure I did a bad job explaining my issue, but I am lost on this one. Any help would be appreciated.

[June7]

Build a form with an UNBOUND control (textbox or combobox) for user to input/select this unique number. This form can be set to open by default when the db opens.

Options to filter records:

1. dynamic parameterized query that references the control as input parameter

2. apply that input value as filter criteria for another form or report - pass the value to the form/report when it opens

DoCmd.OpenForm "form name", , , "ID=" & Me.controlname

3. have the default form bound to the data and the criteria control in the form header, use parameterized query as form RecordSource or use code to set form Filter and FilterOn properties http://allenbrowne.com/ser-62code.html

[burrina]

No, the question makes sense. One way would be to use a Combo Box with a list of as you say unique id's. Then using the AfterUpdateEvent, populate your fields with the values.
Me.SomeField =[MyComboBoxName].Column(X) 'Remember it starts as 0

[gentrym]

Thanks for the responses. I'll play around with what you guys said (although some of it is greek to me).

[gentrym]

Ok, I quickly found out I have no idea how to do what you guys are talking about. I understand the big picture, but have no idea how to actually do it. Is there any way to explain it easier terms? Or do it without VBA codes or whatever?

[June7]

Examples of using dynamic parameterized query:

http://www.datapigtechnologies.com/f...mtoreport.html
http://www.datapigtechnologies.com/f...earchform.html
http://www.datapigtechnologies.com/f...tomfilter.html

Those examples are all for text data type fields and use the LIKE operator with wildcard. LIKE and wildcard doesn't work with number or date/time type fields. Just use = operator in the parameter for the unique identifier field.