Please assist on this task. I'm stuck.

[Playerpawn]

Please, please help if you know what I need to do. I need to get this done and I'm stuck.

I'll explain what I have, then what I'm trying to do.



A form (frm_start) with two controls, an editable field that's unbound (text_input) and an OK button (control_ok). Also, I have a query (qry_start) that wants 1 input (user_input) and will return 1 row, 3 columns from a table.

What I want to do is, the user starts at the form (frm_start) and inputs a value into the (text_input) then clicks OK (control_ok), at this point, it takes that value supplied and passes it into (qry_start) as the (user_input) arguement that's required, then the returned 3 columns of data is opens another form (frm_ending) and passes those 3 columns of data into that form as arguements so I can have the newly opened form do things based on those.

In example, user inputs "Magic1" and clicks okay, the query gets ran suppling "Magic1" as the required user input, this query will return 3 columns of data (1 row) which will now open another form passing these 3 values into the new form as arguements. The 'new form' uses these arguements to fill in existing boxes and to format properly.

I hope anyone who took time to read this can help. I don't know Access functions/syntax well enough to code this.

[June7]

Passing fields to a form, not sure what this is about. Bind the second form to the table or query the record will come from then supply the user input as filter criteria for the form in the OpenForm method. Like:
DoCmd.OpenForm "form name", , , "field name ='" & Me.inputboxname & "'"

The values in the three fields are available for code behind the second form. What is it you want to do with them?

[Playerpawn]

To clarify what I'm trying to do,

On the first form there's one editable textbox for the user to enter the name of an item. In my example, this is "Magic1". When they click OK, I need to code it so "Magic1" is supplied to qry_start which looks something like:

SELECT part_name, part_type, part_codes
FROM part_master
WHERE part_name = (USER INPUT HERE)

So now that they clicked OK, and this query returned probably:

MAGIC1, MAGIC_STUFF, 12

I want to pass these 3 values as arguements into another opening form. This new opening form is used to log stuff about the item.

Therefore, the new form will open and using these 3 values I will code it so:

MAGIC1 is used to auto populate a part_name field
MAGIC_TYPE is used to auto populate a part_type field
12 (part_codes) is used to format the form. For example, the form may have 5 fields for logging information but due to part_code 12 I will hide the 3rd one because it doesn't apply.

So ultimately, I have 2 forms, one query.

First form is where a part is entered, runs the query, then opens the actual logging form with arguements supplied from the query to doctor the form accordingly.

[June7]

Use DLookup or SELECT sql in VBA code or bind forms/reports to query to retrieve values.

Sounds like duplication of data (the part_type value). With properly related tables and form/subform arrangements, this should not be necessary and much simpler.

However, if you must, then instead of feeding value to query, combine all this into one form. Form opens to new record, user enters criteria, DLookup expression in textboxes or in VBA retrieve the related values, code saves values and formats form (controls are not visible until criteria entered and triggers code to make appropriate controls visible).